Microsoft Office Tutorials and References

In Depth Information

**Increase or Decrease Decimals**

EXCEL

chapter
9

Increase or Decrease

Decimals

Building Spreadsheets

You can control the number of decimals that appear

with numeric data using the Increase Decimal and

Decrease Decimal buttons. For example, you may want to

increase the number of decimals shown in a cell, or reduce

the number of decimals in a formula result.

Increase or Decrease Decimals

1
Select the cell or range that you

want to format.

2
Click the
Home
tab on the

Ribbon.

3
Click a decimal button.

2

3

You can click
Increase Decimal

( ) to increase the number of

decimals.

You can click
Decrease Decimal

( ) to decrease the number of

decimals.

1

Excel adjusts the number of

decimals that appear in the cell

or cells.

●

This example removes one

decimal.

●

You can click
Decrease Decimal

( ) again to remove another

decimal.

155