Microsoft Office Tutorials and References
In Depth Information
To Apply an Accounting Style Format and Comma Style Format Using the Ribbon
To Apply an Accounting Style Format and Comma Style Format Using the Ribbon
The following steps show how to assign formats using the Accounting Number Format button and the
Comma Style button on the Ribbon.
1
Select the range E4:I4.
Accounting Number
Format button
While holding down the CTRL key,
select the ranges F13:I13.
Click the Accounting Number
Format button on the Ribbon
(Figure 2–41) to apply the
Accounting style format with fi xed
dollar signs to the nonadjacent
ranges E4:I4 and F13:I13
(Figure 2–41).
What is the effect of applying the
Accounting style format?
The Accounting Number Format
button assigns a fi xed dollar sign
to the numbers in
the ranges E4:I4 and
F13:I13. In each cell in
these ranges, Excel dis-
plays the dollar sign to
the far left with spaces between it
and the fi rst digit in the cell.
Excel displays nonadjacent
ranges E4:I4 and F13:I13 using
the Accounting style format
with fi xed dollar signs
Figure 2–41
2
Select the range E5:I12.
Click the Comma Style button on
the Ribbon to assign the Comma
style format to the range E5:I12
(Figure 2–42).
Comma Style button
width of columns
automatically
increased due to
formatting
range E5:I12 selected
parentheses indicate
number is negative
Excel displays range
E5:I12 using Comma
style format
 
 
Search JabSto ::




Custom Search