Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet EX 197
Select the range
Format Cells:
Number Dialog
Box Launcher
While holding down
the CTRL key, select
the nonadjacent
ranges B6:H6,
B9:H9, B14:H14, and
B16:H16, and then
release the CTRL key.
Format Cells
dialog box
Click the Format
Cells: Number
Dialog Box
Launcher on the
Ribbon to display
the Format Cells
dialog box
(Figure 3–36).
nonadjacent ranges
B4:H4, B6:H6, B9:H9,
B14:H14, and B16:H16
Figure 3–36
Click Currency in the
Category list, select
2 in the Decimal
places box, click $
in the Symbol list
to ensure a dollar
sign shows, and click
the black font color
($1,234.10) in the
Negative numbers
list (Figure 3–37).
Why was the
particular style
chosen for the
negative numbers?
In accounting,
negative numbers
often are shown
with parentheses
surrounding the
value rather than
with a negative sign
preceding the value.
Thus, the format
(1,234.10) in the
Negative numbers list was clicked. The data being used in this chapter contains no negative
numbers. However, you must select a format for negative numbers, and you must be consistent
if you are choosing different formats in a column, otherwise the decimal points may not line up.
sample of
Currency style to appear
with two decimal places,
dollar sign, and negative
numbers in parentheses
OK button
Figure 3–37
Search JabSto ::

Custom Search