Microsoft Office Tutorials and References
In Depth Information
Working with Percentages
NOTE: The Currency format option in Figure 5–60 is distinguished from the Accounting format
option by the way it positions the currency symbol. In the accounting format, the symbol is
always lined up in the same place. With currency, the symbol is always placed right alongside
the value. In Figure 5–61, the first column of values exhibits the accounting format, and the
second shows the currency format.
Figure 5–61. Symbolic gestures: Accounting and Currency formats
Working with Percentages
The next number button, Percent Style, is represented by—surprise—the percent symbol
(see Figure 5–62).
Figure 5–62. The Percent Style button
Percent Style represents a number as a percentage, and as a result can be a bit tricky.
Again, you just select the desired cell(s) and click the Percent Style button. Thus, the
number 0.34 would appear as follows:
34%
That’s easy enough, but keep in mind that the number 1 expressed in percentage terms
is 100%, not 1%. If you’re expecting that result, you’ll have to enter .01 in the cell before
you click Percent Style.
NOTE: If you actually type the percent symbol alongside a value instead of clicking Percent
Style, you can type and it will mean 1%, and will appear that way in the formula bar. 1%
Punctuating Values
The Comma Style button actually does two things to the values you select:
It adds a comma to any value exceeding 999.
It posts two decimal points.
Thus, click the button on a cell containing 56802, and you’ll get 56,802.00.
 
Search JabSto ::




Custom Search