Number Formatting in Excel 2007

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

So you have a worksheet with some numbers, but they are not your standard type of number… maybe they are a dollar figure, maybe they are a date or time, percentage or fraction.  To make sure Excel 2007 interprets them the way you interpret them, you need to format the number properties the cell.

How to change the Number Formatting of a cell in Excel 2007

Firstly, you need to find the Number group.  You can find it on the “Home” tab of the ribbon.

In the number group you have a number of different options you can use to quickly format the numbers in your selected cells.

The first option is the big drop down box that says “General.”  This drop down box lets you select the type of number formatting you want for the cell, which could be: Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text, or many more.  The drop down list looks like this when you click on it…

Below that drop down box you have a number of other options.  The first is to format the cell as a specific currency.  Using this button you can not only format the cell as an Accounting Cell, but also select the specific currency you want.

The next few options allow you to format the cell for percentages, and set the cell to follow comma style (ie. 2,432,455.00).  The final two buttons allow you to move the decimal point in the cell to the left (increase the number of decimals after the point), or move the decimal point to the right (decrease the number of decimals after the point).

If you want to do some tricky number formatting, you can do so by clicking on the little “Square and Arrow” in the bottom right hand corner of the Number group… or right click on your selected cells, and click “Format Cells”

’till next time,

[tags]Accounting, Spreadsheet, Formatting, Help[/tags]

2 thoughts on “Number Formatting in Excel 2007

  1. Looking for ideas on how to dynamically modify currency formats. Application has currency as a variable. I am working with multiple currencies in the same book. Need to be able to set symbol based on the variable.

    I’ve done it with VBA, but would like to avoid it if possible.

    Any ideas?

  2. Michael,
    I have also been looking for this, I do NOT have a vba solution.
    I have done this with TEXT, but then I cannot continue calculations.
    If you get an answer then pls let me know!
    smostovoy (AT NOSPAM) Yahoo (DOT) com

Leave a Reply

Your email address will not be published. Required fields are marked *