Microsoft Office Tutorials and References
In Depth Information
Using the Format Cells Dialog Box
Figure 3-10:
figures after
cells with
the Comma
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