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.
Search JabSto ::




Custom Search