Microsoft Office Tutorials and References
In Depth Information
To Format Numbers in the Worksheet
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 but-
ton 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, click Number tab,
select Accounting in Category
list or select Number and click
Use 1000 Separator, click OK
button
 
 
Search JabSto ::




Custom Search