Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
2
Click the OK button
(Format Cells dialog
box) to close the
Format Cells dialog
box and apply the
desired format to the
selected ranges.
Comma style format
is same as previous
Currency style, but
without dollar sign
symbol
Select the range
B14:H14 as the next
range to format.
While holding down
nonadjacent ranges
B14:H14, and
B19:H22 selected
the CTRL key, select
the range B19:H22,
and then release the
CTRL key to select
nonadjacent ranges.
OK button
Click the Format Cells:
Number Dialog Box
Launcher (Home tab |
Number group) to
display the Format Cells dialog box.
Figure 3 – 42
Click Currency in the Category list (Format Cells dialog box), if necessary select 2 in the Decimal
places box, click None in the Symbol list so a dollar sign does not show in the cells to be formatted,
and click the black font color (1,234.10) in the Negative numbers list (Figure 3–42).
3
Click the OK button
(Format Cells dialog
box) to close the
Format Cells dialog
box and apply the
desired format to
the selected ranges.
Currency style
with l oating
dollar sign
Comma style
Select cell B27 to select
an empty cell and
display the formatted
numbers as shown
in Figure 3 – 43.
Why is the Format Cells
dialog box used to
create the style for the
ranges in Steps 2 and 3?
The Format Cells dialog box is used to assign the Comma style, because the Comma Style
button (Home tab | Number group) assigns a format that displays a dash (–) when a cell
has a value of 0. The specii cations for this worksheet call for displaying a value of 0 as 0.00
(see cell B18 in Figure 3 – 40) rather than as a dash. To create a Comma style using the Format
Cells dialog box, you can assign a Currency style with no dollar sign.
Figure 3 – 43
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click Number tab
(Format Cells dialog box),
click category in Category list,
select format, click OK button
(Format Cells dialog box)
2. Press CTRL + 1 , click Number
tab (Format Cells dialog
box), click category in
Category list, select format,
click OK button (Format
Cells dialog box)
 
Search JabSto ::




Custom Search