Number Formatting in MS Excel 2007

Dennis Faas's picture

Sometimes within your worksheet, you may have different, non-standard numbers. Perhaps you have dates and times and currency numbers. If you want MS Excel 2007 to interpret these different, non-standard numbers the way that you do, you will need to format the number properties in the cell in which they appear.

Follow the steps below to change the number formatting of a cell in MS Excel 2007:

  • On the Home tab of the Ribbon, find the Number group.  
  • In the Number group, there are various different options you can use to quickly format the numbers in your selected cells.  
  • The first option you will see is the big drop-down box named General, which will allow you to select the type of number formatting you want for the cell.  
  • You can select from Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, etc.  
  • Below the drop-down box you will see many options, such as Currency. Using that button you can format the cell as an Accounting Cell and even select the specific currency you would like to use.

There are other options that allow you to format the cell for percentages and set the cell to follow comma style. The last two buttons will allow you to move the decimal point in the cell to the left or right. If you care to do some tricky number formatting, you can click on the Square and Arrow in the bottom right-hand corner of the Number group or select your cells and right click and click on Format Cells.

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
No votes yet