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?)