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

Result:

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.

Calculation

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

Do you like this free website? Please follow us on Google+