What-If Analysis, Charting, And Working With Large Worksheets Page 39
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 175
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
•
Select the range
without dollar sign
symbol
B14:H14 as the next
range to format.
nonadjacent ranges
•
While holding down
B14:H14, and
the
key, select
B19:H22 selected
CTRL
the range B19:H22,
and then release the
key to select
OK button
CTRL
nonadjacent ranges.
•
Click the Format Cells:
Number Dialog Box
Launcher (Home tab |
Figure 3 – 42
Number group) to
display the Format Cells dialog box.
•
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
Currency style
Comma style
with fl oating
desired format to
dollar sign
the selected ranges.
•
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
Figure 3 – 43
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 specifi 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.
Other Ways
1. Right-click range, click
select format, click OK button
Category list, select format,
Format Cells on shortcut
(Format Cells dialog box)
click OK button (Format
menu, click Number tab
Cells dialog box)
+
,
2. Press
1
click Number
CTRL
(Format Cells dialog box),
tab (Format Cells dialog
click category in Category list,
box), click category in
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education