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