Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To Apply a Currency Style Format with a Floating Dollar Sign Using the
Format Cells Dialog Box
The following steps use the Format Cells dialog box to apply the Currency style format with a l oating dollar
sign to the numbers in the range E14:I16.
1
Home tab
Format Cells dialog box
Select the range
E14:I16 and then
click the Format Cells:
Number Dialog Box
Launcher (Home tab
| Number group) to
display the Format
Cells dialog box.
Number tab
If necessary, click
the Number tab
(Format Cells dialog
box) to display the
Number tab (Format
Cells dialog box)
(Figure 2 – 44).
Range E14:I16
selected
Figure 2 – 44
2
Click Currency in the
Category list to select
the necessary number
format category, and
then click the third
style ($1,234.10) in
the Negative numbers
list (Format Cells
dialog box) to select
the desired currency
format for negative
numbers (Figure 2 – 45).
sample of how number in
upper-left cell of selected
range will appear
Currency style
selected
number of decimal places
$ symbol selected
Negative
numbers list
How do I select the
proper format?
You can choose from
12 categories of
formats. Once you
select a category, you
can select the number
of decimal places,
whether or not a
dollar sign should be
displayed, and how
negative numbers should appear. Selecting the appropriate negative numbers format is
important, because doing so adds a space to the right of the number in order to align the
numbers in the worksheet on the decimal points. Some of the available negative number
formats do not align the numbers in the worksheet on the decimal points.
OK button
Figure 2 – 45
 
Search JabSto ::




Custom Search