Microsoft Office Tutorials and References
In Depth Information
Formatting numbers
Finally, the Accounting format is the only built-in format that includes formatting
criteria for text. It includes spaces equivalent to the width of a parenthesis on each side
of text so that it too lines up evenly with the numbers in a column.
Typically, when creating a GAAP-friendly worksheet of currency values, you would use
currency symbols only in the top row and in the totals row at the bottom of each column
of numbers. This makes good sense because using dollar signs with every number would
make for a much busier table. The middle of the table is then formatted using a compatible
format without currency symbols, as shown in Figure 9-37.
Figure 9-37 It is standard practice to use currency symbols only in the top and bottom rows of a
Luckily, Excel makes it easy for you to format this way by using buttons in the Number
group on the Home tab. Despite seemingly incompatible button names, both the
Accounting Number Format button and the Comma Style button apply Accounting formats
adhering to the rules described earlier. So, to format the numeric entries in the table shown in
Figure 9-37, select the first and last rows of numbers, click the Accounting Number Format
button, then select all the cells containing numbers in between, and click the Comma Style
button. (We then selected all the numeric cells in the table and clicked the Decrease
Decimal button twice to hide all the decimal values. We also hid worksheet gridlines, by clearing
the Gridlines option on the View tab, to simplify the appearance.)
Search JabSto ::

Custom Search