Microsoft Office Tutorials and References

In Depth Information

**Using the Format Cells Dialog Box**

Figure 3-11:

Monthlyto-quarterly

sales

percentages with

Percentage

number

formatting.

Deciding how many decimal places

You can increase or decrease the number of decimal places used in a number

entered by using the Accounting Number Format, Comma Style, or Percent

Style button in the Number group of the Home tab simply by clicking the

Increase Decimal button or the Decrease Decimal button in this group. Each

time you click the Increase Decimal button (the one with the arrow pointing

left), Excel adds another decimal place to the number format you apply.

The values behind the formatting

Make no mistake about it — all that these fancy number formats do is spiff up

the presentation of the values in the worksheet. Like a good illusionist, a

particular number format sometimes appears to transform some entries, but in

reality, the entries are the same old numbers you started with. For example,

suppose that a formula returns the following value:

25.6456

Now suppose that you format the cell containing this value with the

Accounting Number Format button on the Home tab. The value now appears

as follows:

$25.65