Microsoft Office Tutorials and References

In Depth Information

**Change the Number of Decimal Places Displayed**

5

chapter

Formatting Excel Ranges

Increase the Number of Decimal

Places

1
Select the range you want to

format.

2
Click the
Home
tab.

3
Click the
Increase Decimal

button (

).

B
Excel increases the number of

decimal places by one.

4
Repeat Step
until you get
3

the number of decimal places

you want.

My range currently has values that display different numbers of decimal places. What

happens when I change the number of decimal places?

In this situation, Excel uses the value that has the most displayed decimal places as the basis

for formatting all the values. For example, if the selected range has values that display no,

one, two, or four decimal places, Excel uses the value with four decimals as the basis. If you

click
Decrease Decimal
, Excel displays every value with three decimal places; if you click

Increase Decimal
, Excel displays every value with five decimal places.