Microsoft Excel 2007 with Example

4 Format Cells:

4.1 Format Cells: 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 two times. Notice the button next to it to show more decimal places.

Click Decrease Decimal Two Times

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.