Microsoft Office Tutorials and References
In Depth Information
To Assign a Currency Style Using the Format Dialog Box
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 fl oating dollar signs in the fi rst row of numbers (row 5) and the
totals row (row 12). Recall that while a fi xed dollar sign always appears in the same position in a cell (regardless of
the number of signifi cant digits), a fl oating dollar sign always appears immediately to the left of the fi rst signifi -
cant digit in the cell. To assign a fi 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 fl 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 fl oating dollar sign and
two decimal places to the ranges C5:G5 and D12:G12.
1
Select the range C5:G5.
While holding down
the CTRL key, select
the nonadjacent
range D12:G12 and
then right-click the
selected ranges to
highlight the non-
adjacent ranges and
display the shortcut
menu (Figure 6–19).
shortcut
menu
nonadjacent
ranges selected
Format Cells
command
Figure 6–19
 
 
Search JabSto ::




Custom Search