Table of Contents

Decimal Places

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

Decrease Decimal

To decrease the number of decimal places displayed for a cell simply click the Decrease Decimal button in Excel.

1. For example 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.

Increase Decimal

To show more decimal places use the Increase Decimal button in Excel.

1. For example select the range B1:B5 below.

Integers

Note: these numbers look like integers (whole numbers).

2. On the Home tab in the Number group click the Increase Decimal button six times.

Increase Decimal

Result:

Show More Decimals

Note: Excel stores the exact values of numbers even if you can’t see all the decimal places (except when you’re using functions to change the number of decimal places which we will see next).

Useful Functions

Excel offers several useful functions to change the number of decimal places of a number.

1. The ROUND function below rounds a number to two decimal places.

Round to Two Decimal Places in Excel

Note: if you round a number you lose precision. For example if you’re using the value in cell B1 in calculations Excel uses the value 114.73 (not 114.7261).

2. The TRUNC function in Excel removes decimal places from a given number (without rounding).

Remove Decimals

Note: if you use the TRUNC function you lose precision. Use the second argument to specify how many decimals you want to keep.

3. To extract only the decimal part of a number use the following formula.

Decimal Part

Tip: visit our chapter about rounding numbers in Excel for more information and examples.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog