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
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]