Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Formatting Numbers Using the Ribbon
As shown in Figure 2 – 30b on page EX 92, the worksheet is formatted to resemble
an accounting report. For example, in columns E through I, the numbers in the i rst row
(row 4), the totals row (row 13), and the rows below the totals (rows 14 through 16) have
dollar signs, while the remaining numbers (rows 5 through 12) in column E through
column I do not.
Determine proper formatting for cells that include currency and other
To append a dollar sign to a number, you should use the Accounting number format. Excel
displays numbers using the Accounting number format with a dollar sign to the left of
the number, inserts a comma every three positions to the left of the decimal point, and
displays numbers to the nearest cent (hundredths place). Clicking the Accounting Number
Format button (Home tab | Number group) assigns the desired Accounting number format.
When you use the Accounting Number Format button to assign the Accounting number
format, Excel displays a i xed dollar sign to the far left in the cell, often with spaces
between it and the i rst digit. To assign a l oating dollar sign that appears immediately to
the left of the i rst digit with no spaces, use the Currency style (Format Cells dialog box).
Whether you use the Accounting number format or the Currency style format depends on
a number of factors, including the preference of your organization, industry standards, and
the aesthetics of the worksheet.
The Comma style format is used to instruct Excel to display numbers with commas and no
dollar signs. The Comma style format , which can be assigned to a range of cells by clicking the
Comma Style button (Home tab | Number group), inserts a comma every three positions to
the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
To Apply an Accounting Number Format and Comma Style Format Using the Ribbon
The following steps assign formats using the Accounting Number Format button and the Comma Style
button (Home tab | Number group). The Accounting Number format is applied to the currency amounts in rows 4
and 13. The Comma style is applied to the range E4:I12 and to column D (Hours Worked).
Select the range to contain the
Accounting Number Format, cells
E4:I4 in this case.
While holding down the
select the range F13:I13 to select the
Click the Accounting Number
Format button (Home tab | Number
group) to apply the Accounting
number format with i xed dollar
signs to the selected nonadjacent
ranges (Figure 2 – 41).
What is the effect of applying
the Accounting number format?
The Accounting Number Format
button assigns a i xed dollar
sign to the numbers in the
ranges E4:I4 and F13:I13. In each cell
in these ranges, Excel displays the
dollar sign to the far left with spaces
between it and the i rst digit in the cell.
range E4:I4 and
F13:I13 using the
format with i xed
Figure 2 – 41