Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Comma Style button
3
Select the range to contain the
comma style format, cells C4:C16
in this case.
Tap or click the Comma Style
button (HOME tab | Number
group) to assign the comma style
format to the selected range
(Figure 2 – 40).
range C4:C16 selected
Figure 2 – 40
To Apply a Currency Style Format with a Floating
Dollar Sign Using the Format Cells Dialog Box
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
Why? The Format Cells dialog box can be used to apply formatting that is not available directly on the ribbon.
The following steps use the Format Cells dialog box to apply the currency style format with a oating dollar
sign to the numbers in the ranges D14:G16 and I14:I16.
1
Select the ranges (D14:G16 and
I14:I16) and then tap or click
the Number Format Dialog Box
Launcher (HOME tab | Number
group) to display the Format Cells
dialog box.
If necessary, tap or click the
Number tab to display the Number
sheet (Format Cells dialog box).
Tap or click Currency in the
Category list to select the
necessary number format category
and then tap or click the third
style ($1,234.10) in the Negative
numbers list to select the desired
currency format for negative
numbers (Figure 2 – 41).
Format Cells
dialog box
Number Format Dialog
Box Launcher
Number tab
Currency style
selected
number format
selected
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 – 41
 
Search JabSto ::




Custom Search