Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
2
Home tab
Accounting Number
Format button
Click the Accounting
Number Format
button (Home tab |
Number group) to
apply the Accounting
Number format to the
cells in the selected
range.
Number group
range B5:H8
selected
Select the range B5:H8
(Figure 1– 46).
Accounting
Number Format
applied to range
B4:H4
cell widths automatically adjusted
to accommodate new formatting
Figure 1– 46
What effect does the Accounting Number format have on the selected cells?
The Accounting Number format causes the cells to be displayed with two decimal places so
that decimal places in cells below the selected cells align vertically. Cell widths are adjusted
automatically to accommodate the new formatting.
Comma Style
button
3
Home tab
Click the Comma
Style button (Home
tab | Number group)
to apply the Comma
Style format to the
selected range.
Select the range B9:H9
Number group
to make it the active
range (Figure 1– 47).
Comma Style
format applied
to range B5:H8
range B9:H9 selected
Figure 1– 47
What effect does the Comma Style format have on the selected cells?
The Comma Style format causes the cells to be displayed with two decimal places and
commas as thousands separators.
 
Search JabSto ::




Custom Search