Microsoft Office Tutorials and References
In Depth Information
Change the Number of Decimal Places Displayed
Formatting Excel Ranges
Increase the Number of Decimal
1 Select the range you want to
2 Click the Home tab.
3 Click the Increase Decimal
B Excel increases the number of
decimal places by one.
4 Repeat Step until you get 3
the number of decimal places
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.