-
Select the cells to format.
-
On the Home tab, choose either Increase Decimal or Decrease Decimal.
If increase or decrease decimal are missing or don't work, select Number first.
Note: This only displays a rounded number in a cell, the original number is still intact for calculation and formulas.
-
Select the cells to format.
-
On the Home tab, choose either Increase Decimal or Decrease Decimal.
If increase or decrease decimal don't work, select Number on the ribbon, or are missing, choose the ellipsis (...) on the right first.
Note: This only displays a rounded number in a cell, the original number is still intact for calculation and formulas.