Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
2
Tap or click the OK button (Format
Cells dialog box) to assign the
currency style format with a
oating dollar sign to the selected
ranges (Figure 2 – 42).
What is the difference between
using the accounting number
style and currency style?
When using the ‘Accounting
Number Format’ button, recall that a
oating dollar sign always appears immediately to the left of the rst
digit, and the xed dollar sign always appears on the left side of the cell.
currency style applied
to selected ranges
Figure 2 – 42
Other Ways
1. Press CTRL + 1 , tap or click Number tab (Format Cells dialog box), tap or
click Currency in Category list, select format, tap or click OK button
2. Press CTRL + SHIFT + DOLLAR SIGN (\$)
To Apply a Percent Style Format and
Use the Increase Decimal Button
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
The next step is to format the tax percentage in column H. Why? Currently, Excel displays the numbers
as decimal fractions when they should appear as percentages. The following steps format the range H4:H16 to the
percent style format with two decimal places.
1
Select the range to format, cells
H4:H16 in this case.
Tap or click the Percent Style
button (HOME tab | Number
group) to display the numbers in
the selected range as a rounded
whole percent.
Increase Decimal
button
Percent Style button
What is the result of tapping or
clicking the Percent Style button?
The Percent Style button instructs
Excel to display a value as a
percentage, determined by
multiplying the cell entry by 100,
rounding the result to the nearest
sign. For example, when cell H4 is
formatted using the Percent Style
buttons, Excel displays the actual
value 0.246383 as 25%.
range H4:H16
selected
Figure 2 – 43
2
Tap or 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 – 43).
Other Ways
1. Press and hold or right-click selected range, tap or click
Format Cells on shortcut menu, tap or click Number
tab (Format Cells dialog box), tap or click Percentage in
Category list, select format, tap or click OK button
2. Press CTRL + 1, tap or click Number tab
(Format Cells dialog box), tap or click
Percentage in Category list, select
format, tap or click OK button
3. Press CTRL + SHIFT + PERCENT SIGN (%)

Search JabSto ::

Custom Search