Microsoft Office Tutorials and References
In Depth Information
To Assign Formats to Nonadjacent Ranges
1
Select the range
B4:H4.
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
Format Cells:
Number Dialog
Box Launcher
Click the Format
Cells: Number
Dialog Box
Launcher on the
Ribbon to display
the Format Cells
dialog box
(Figure 3–36).
Currency
category
nonadjacent ranges
B4:H4, B6:H6, B9:H9,
B14:H14, and B16:H16
selected
Figure 3–36
2
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
format
Currency style to appear
with two decimal places,
dollar sign, and negative
numbers in parentheses
OK button
Figure 3–37
 
 
Search JabSto ::




Custom Search