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




Custom Search