Decimal Places


Learn how to show fewer decimal places in Excel without changing the number itself. You can also round a number.

1. Enter the value 2.175 into cell A1.

Three Decimal Places in Excel

2. On the Home tab, in the Number group, click the Decrease Decimal button twice.

Decrease Decimal


One Decimal Place

Note: if you look at the formula bar, you can see that cell A1 still contains the value 2.175.

3. We can still use this underlying precise value in calculations.


Note: if you want to use 2.2 to get a result of 6.6, round the value in cell A1.

Previous articleCount Blank/Nonblank Cells in Excel
Next articleDynamic Named Range in Excel