Microsoft Office Tutorials and References
In Depth Information
Using the Format Cells Dialog Box
Figure 3-10:
Monthly
sales
figures after
formatting
cells with
the Comma
Style
number
format.
Playing around with Percent Style
Many worksheets use percentages in the form of interest rates, growth
rates, inflation rates, and so on. To insert a percentage in a cell, type the
percent sign (%) after the number. To indicate an interest rate of 12 percent,
for example, you enter 12% in the cell. When you do this, Excel assigns a
Percentage number format and, at the same time, divides the value by 100
(that’s what makes it a percentage) and places the result in the cell (0.12 in
this example).
Not all percentages in a worksheet are entered by hand in this manner. Some
may be calculated by a formula and returned to their cells as raw decimal
values. In such cases, you should add a Percent format to convert the
calculated decimal values to percentages (done by multiplying the decimal value
by 100 and adding a percent sign).
The sample first-quarter-sales worksheet just happens to have some
percentages calculated by formulas in row 12 that need formatting (these formulas
indicate what percentage each monthly total is of the first-quarter total in cell
E10). In Figure 3-11, these values reflect Percent Style formatting. To
accomplish this feat, you simply select the cells and click the Percent Style button
in the Number group on the Home tab. (Need I point out that it’s the button
with the % symbol?)
Search JabSto ::




Custom Search