Archive for October, 2009

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

Hey everyone… welcome to October! (OMG almost Christmas!)

I am sure almost everyone who is reading this post has Excel installed on their computer at work or at university.  But how many of you really know what Excel is really capable of?

This month I am going to focus on Excel 2007 content.  One Excel 2007 tutorial each day for the entire month… 31 posts that will help you master Excel (and not the other way around!)

So are you ready to excel at Excel?  (sorry, had to do it!)  Stay tuned!

‘till next time!
TNP