Help, tips, tricks and tutorials for Microsoft Office 2007 - The New Paperclip
2nd October
2009
written by The New Paperclip




Are you working with numbers in Excel 2007 that include decimal points? 

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP ;)

Share and Enjoy:
  • del.icio.us
  • E-mail this story to a friend!
  • StumbleUpon

Related posts:

  1. Number Formatting in Excel 2007
  2. Increase the number of upcoming appointments in the Outlook 2007 To-Do Bar
  3. Increase/Decrease AutoRecover Frequency in Word 2007
  4. Add Commas to your numbers in Excel 2007
  5. Excel 2003 buttons and commands in Excel 2007

3 Comments

  1. Ben
    30/10/2009

    Um, I thought there was going to be one a day throughout October. What happened to the 3rd through to today?

  2. 30/10/2009

    Ahhh yep… that happens when you schedule your posts to be published in October 2010! Hands up who is an idiot – that would be me.

    Might take the time to fix them up a bit now :)

  3. Marq
    03/11/2009

    I wonder if there’s a way to define keyboard shortcuts to these two buttons. Worked for me in Excel 2003 and I#m missing the feature in 2007. Any ideas?

Leave a Reply

Join the Office 2007 Tips and Tricks Newsletter Name:Email:
-->