Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
3
Click the OK button (Format Cells
dialog box) to assign the Currency
style format with a l oating
dollar sign to the selected range
(Figure 2 – 46).
Excel displays range
E14:I16 using Currency
style format with
l oating dollar signs
What is the difference between
using the Accounting Number
style and Currency style?
When using the Accounting Number
Style button, recall that a l oating dollar sign always appears immediately to the left of the i rst
digit, and the i xed dollar sign always appears on the left side of the cell. Cell E4, for example,
has a i xed dollar sign, while cell E14 has a l oating dollar sign. The Currency style was assigned
to cell E14 using the Format Cells dialog box and the result is a l oating dollar sign.
Figure 2 – 46
Other Ways
1. Press CTRL + 1, click
Number tab (Format Cells
dialog box), click Currency
in Category list, select
format, click OK button
2. Press CTRL + SHIFT + DOLLAR
SIGN ($)
To Apply a Percent Style Format and Use the Increase Decimal Button
The next step is to format the tax % in column J. Currently, Excel displays the numbers in column J as a
decimal fraction (for example, 0.256 in cell J4). The following steps format the range J4:J16 to the Percent style
format with two decimal places.
Percent Style
button
Increase Decimal
button
1
J4:J16 in this case.
Select the range to format, cell
Decrease Decimal
button
Click the Percent Style button (Home
tab | Number group) to display the
numbers in the selected range as a
rounded whole percent.
Number group
What is the result of clicking the
Percent Style button?
The Percent Style button instructs
Excel to display a value as a percent-
age, determined by multiplying the
cell entry by 100, rounding the result
to the nearest percent, and adding a
percent sign. For example, when cell
J4 is formatted using the Percent Style
buttons, Excel displays the actual value
0.256 as 26%.
Excel displays range
J4:J16 using Percent
style format with
two decimal places
2
Click the Increase Decimal button
(Home tab | Number group) two
times to display the numbers in the
selected range with two decimal
places (Figure 2 – 47).
Figure 2 – 47
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click Number tab
(Format Cells dialog
box), click Percentage
in Category list, select
format, click OK button
2. Press CTRL + 1, click Number
tab (Format Cells dialog
box), click Percentage
in Category list, select
format, click OK button
3. Press CTRL + SHIFT + percent
sign (%)
 
Search JabSto ::




Custom Search