Jump to content


Photo

Excel 2010 Rounding Decimals


1 reply to this topic

#1 Phil

Phil

    Newbie

  • Members
  • Pip
  • 1 posts
  • LocationFeura Bush, NY, USA

Posted 01 March 2015 - 12:51 PM

 Working  In session 2.1.  Entered decimals are rounding to whole numbers in cells, even when formula bar continues to show the number as a decimal. Please see cell  F4.

 

Attached Images

  • Excel Number Round Up.PNG


#2 Mike

Mike

    Advanced Member

  • Administrators
  • 175 posts

Posted 01 March 2015 - 07:17 PM

Hi Phil

 

When you've advanced a little further through the course you'll discover how to show as few or many decimal places as you wish in the lesson:

 

Lesson 4-3: Format numbers using built-in number formats

 

But don't jump ahead in the course to session 4.  Just keep progressing lesson by lesson as knowledge builds upon knowledge as you advance through the course and new skills are introduced.

 

Best Regards

 

 

Mike Smart


Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.




Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users