Microsoft Office Tutorials and References
In Depth Information
EX 198
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
3
Click the OK button.
Select the range
B5:H5.
Comma style format is
same as previous Currency
style, but without dollar
sign symbol
While holding down
the CTRL key, select
the range B10:H13,
and then release the
CTRL key.
Click the Format
Cells: Number Dialog
Box Launcher on the
Ribbon to display
the Format Cells
dialog box.
nonadjacent
ranges B5:H5, and
B10:H13 selected
When Excel displays
the Format Cells
dialog box, click
Currency in the
Category list, select
2 in the Decimal
places box, click
None in the Symbol
list so a dollar sign
does not show, and click
the black font color (1,234.10) in the Negative numbers list (Figure 3–38).
OK button
Figure 3–38
4
Click the OK button.
Press CTRL + HOME
to select cell A1
to display the
formatted numbers
as shown in
Figure 3–39.
Currency style
with fl oating
dollar sign
Comma style
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click Number
tab, click category in
Category list, select
format, click OK button
2. Press CTRL +1, click
Number tab, click
category in Category
list, select format, click
OK button
Figure 3–39
Search JabSto ::




Custom Search