Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet EX 45
3
Click the Comma Style
button on the Ribbon
to apply the Comma
Style to the range
B5:G8.
Select the range B9:G9
(Figure 1–67).
What effect does
the Comma Style
format have on the
selected cells?
The Comma Style
format causes the cells
to display with two
decimal places and
commas as thousands
separators.
Comma
Style
button
range
B9:G9
selected
Comma Style
format applied to
range B5:G8
Figure 1–67
4
Click the Accounting
Number Format
button on the Ribbon to
apply the Accounting
Number format to the
cells in the range
B9:G9.
Accounting Number
Format button
Select cell A11
(Figure 1-68).
Accounting Number
format applied to
range B9:G9
A11 is
active cell
Figure 1–68
Other Ways
1. Click Accounting Number
Format or Comma button
on Mini toolbar
2. Right-click selection, click
Format Cells on the shortcut
menu, select Accounting
in Category list or select
Number and click Use 1000
Separator, click OK button
Search JabSto ::




Custom Search