Microsoft Office Tutorials and References

In Depth Information

**Change the Number of Decimal Places Displayed**

Change the Number of

Decimal Places Displayed

You can make your numeric values easier to read and

interpret by adjusting the number of decimal places

that Excel displays. For example, you might want to

ensure that all dollar-and-cent values show two

decimal places, while dollar-only values show no

decimal places. Similarly, you can adjust the display

of percentage values to suit your audience by

showing more decimals (greater accuracy but more

difficult to read) or fewer decimals (less accuracy but

easier to read).

You can either decrease or increase the number of

decimal places that Excel displays.

Change the Number of Decimal Places Displayed

Decrease the Number of Decimal

Places

1
Select the range you want to

format.

2
Click the
Home
tab.

3
Click the
Decrease Decimal

button (

).

A
Excel decreases the number of

decimal places by one.

4
Repeat Step
until you get
3

the number of decimal places

you want.