Jump to content


Excel 2010 Rounding Decimals

1 reply to this topic

#1 Phil



  • 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


    Advanced Member

  • Administrators
  • 190 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