Microsoft Office Tutorials and References
In Depth Information
Using the Format Cells Dialog Box
The Accounting number format adds a dollar sign, commas between
thousands of dollars, and two decimal places to any values in a selected range. If
any of the values in the cell selection are negative, this number format
displays them in parentheses (the way accountants like them). If you want a
minus sign in front of your negative financial values rather than enclosing
them in parentheses, select the Currency format on the Number Format
dropdown menu or on the Number tab of the Format Cells dialog box.
You can see in Figure 3-9 that only the cells containing totals are selected
(cell ranges E3:E10 and B10:D10). This cell selection was then formatted
with the Accounting number format by simply clicking its command button
(the one with the $ icon, naturally) in the Number group on the Ribbon’s
Home tab.
Figure 3-9:
The totals in
the Mother
Goose sales
table after
clicking the
button on the
Home tab.
Although you could put all the figures in the table into the Accounting number
format to line up the decimal points, this would result in a superabundance
of dollar signs in a fairly small table. In this example, I only formatted the
monthly and quarterly totals with the Accounting number format.
“Look, Ma, no more format overflow!”
When I apply the Accounting number format to the selection in the cell
ranges of E3:E10 and B10:D10 in the sales table shown in Figure 3-9, Excel
adds dollar signs, commas between the thousands, a decimal point, and two
Search JabSto ::

Custom Search