Microsoft Office Tutorials and References
In Depth Information
Increase or Decrease Decimals
CHAPTER
9
Increase or Decrease Decimals
You can control the number of decimal places that appear in numbers using the Increase Decimal
and Decrease Decimal buttons. You may want to increase the number of decimal places shown
in a cell if your worksheet contains data that must be precise to be accurate, as with worksheets
containing scientific data. If the data in your worksheet is less precise, you might reduce the number
of decimal places shown. Depending on the purpose of your worksheet’s sales data, you might show
two decimal places or no decimal places.
Increase or Decrease Decimals
1 Select the cell or range for which
you want to adjust the number of
decimal places displayed.
2 Click the Home tab.
3 Click a decimal button:
You can click the Increase Decimal
button ( ) to increase the number
of decimal places displayed.
You can click the Decrease Decimal
button ( ) to decrease the number
of decimal places displayed.
Excel adjusts the number of decimals
that appear in the cell or cells.
A In this example, Excel adds a
decimal place.
You can click the Increase Decimal
button (
) again to add another
decimal.
157
Search JabSto ::




Custom Search