Microsoft Office Tutorials and References
In Depth Information
To Assign a Currency Style Using the Format Dialog Box
As shown in Figure 6–17 on page EX 434, the template for this chapter follows the standard accounting
format for a table of numbers; that is, it contains ﬂ oating dollar signs in the ﬁ rst row of numbers (row 5) and the
totals row (row 12). Recall that while a ﬁ xed dollar sign always appears in the same position in a cell (regardless of
the number of signiﬁ cant digits), a ﬂ oating dollar sign always appears immediately to the left of the ﬁ rst signiﬁ -
cant digit in the cell. To assign a ﬁ xed dollar sign to rows 5 and 12, select the range and then click the Accounting
Number Format button on the Home tab on the Ribbon. Assigning a ﬂ oating dollar sign, by contrast, requires you
to select the desired format in the Format Cells dialog box.
The following steps use the Format Cells dialog box to assign a Currency style with a ﬂ oating dollar sign and
two decimal places to the ranges C5:G5 and D12:G12.
• Select the range C5:G5.
• While holding down
the CTRL key, select
range D12:G12 and
then right-click the
selected ranges to
highlight the non-
adjacent ranges and
display the shortcut
menu (Figure 6–19).