If you are looking for ways to **reduce decimal places in Excel** permanently, then you are in the right place. There are many easy ways to reduce decimal places but all of them do not work to reduce them permanently. So, let’s get into the main article to know more about the ways.

**Table of Contents**hide

## Download Practice Workbook

## 5 Easy Ways to Reduce Decimal Places in Excel Permanently

In the following dataset, we have a list of products with their corresponding **selling prices** and **profits**. But the **profits** are written up to **five** decimal places. If we want to reduce them up to **two** decimal places permanently, then we can follow the **5** procedures stated below.

For creating this article, we have used ** Microsoft Excel 365 **version. However, you can use another version according to your necessary.

__Method-1__: Combining Advanced Option Feature with Number Format

Here, we will customize the number format of the profits, but prior to that, we will activate an option under advanced options.

- Go to
**File**.

- Select
**Options**.

Then, the **Excel Options **dialog box will open up.

- Go to the
**Advanced**tab >> check the**Set precision as displayed**option under**When calculating this workbook**.

All of a sudden, a message box will appear to ensure your last change.

- Press
**OK**.

- Also, in the
**Excel Options**wizard click on**OK**.

Now, return to the worksheet to do the next part.

- Select the range, and then go to the
**Home**tab >> expand the**Number Format**dialog box by clicking on this icon.

Afterward, the **Format Cells **dialog box will open up.

- As our values are in
**Currency**format, go to the**Currency**tab >> select**2**as the value of**Decimal places**>> press**OK**.

Finally, the decimal places of the profits are reduced from **5 **decimal places to **2 **decimal places, and it is permanent as we can see the same value also in the **formula bar**.

**Read More: How to Change Decimal Places in Excel (3 Effective Ways)**

__Method-2__: Using TRUNC Function to Permanently Reduce Decimal Places in Excel

In this section, we will use **the TRUNC function** to minimize the decimal places of the profits permanently.

- Type the following formula in cell
**E4**.

`=TRUNC(D4,2)`

Here, **D4 **is the profit value, and **2 **is the number of the decimal places up to which we want to keep.

- Press
**ENTER**and drag down the**Fill Handle**.

Finally, we will be able to reduce the decimal places of the profits permanently.

**Read More:** **How to Set Decimal Places in Excel with Formula (5 Effective Ways)**

__Method-3__: Applying ROUND Function in Excel

Here, we will show the usage of the **ROUND** and **ROUNDDOWN** functions to decrease the decimal places of the profit values of the following dataset.

- Enter the following formula in cell
**E4**.

`=ROUND(D4,2)`

Here, **D4 **is the profit value, and **2 **is the number of the decimal places up to which we want to keep. **The ROUND function** will round the digit of the **2** decimal place to an upper value if the next digit is **5 **or greater than **5**.

For example, we can see **78.97534 **has been changed into **78.98**.

- Drag down the
**Fill Handle**.

Finally, we will have profits with permanently reduced decimal places.

Now, we will show the difference in the results when we are using **the ROUNDDOWN function**.

- Apply the following formula to get the modified profits.

`=ROUNDDOWN(D4,2)`

Here, **D4 **is the profit value, and **2 **is the number of the decimal places up to which we want to keep. **The ROUNDDOWN function** will reduce the decimal places without changing any digits.

For example, we can see **78.97534 **has been changed into **78.97**.

**Read More:** **How to Remove Decimals in Excel with Rounding (10 Easy Methods)**

**Similar Readings**

**How to Convert Decimal to Days Hours and Minutes in Excel (3 Methods)****Insert Dot between Numbers in Excel (3 Ways)****How to Convert Hours to Decimal in Excel (3 Easy Methods)****Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)****How to Convert Minutes to Decimal in Excel (3 Quick Ways)**

__Method-4__: Applying INT Function for Reducing Decimal Places in Excel Permanently

Here, we will use **the INT function** to perform the task of decreasing the decimal places permanently from the profit values.

- Write down the following formula in cell
**E4**.

`=INT(D4*100)/100`

**Formula Breakdown**

**D4*100 →**becomes**97534*100****Output → 7897.534**

**INT(D4*100) →**becomes**INT(7897.534)****Output → 7897**

**INT(D4*100)/100 →**becomes**7897/100 → 78.97**

- Drag down the
**Fill Handle**.

Finally, the decimal places of the profits are reduced from **5 **decimal places to **2 **decimal places.

**Read More:** **How to Remove Decimal Places in Excel (5 Easy Methods)**

__Method-5__: Combining FLOOR Function with IF Function in Excel

In this section, we are going to use **the FLOOR function** with **the IF function** to perform the reduction of the decimal places of the profits.

- Type the following formula in cell
**E4**.

`=FLOOR(D4,IF(D4>0,0.01,-0.01))`

**Formula Breakdown**

**D4>0 →**it is the logical condition, if the profit value is positive then we will get**TRUE**, otherwise**FALSE**.**Output → TRUE**

**IF(D4>0,0.01,-0.01) →**becomes**IF(TRUE,0.01,-0.01) →**returns**01**for**TRUE**, otherwise**-0.01**.**Output → 0.01**

**FLOOR(D4,IF(D4>0,0.01,-0.01)) →**becomes**FLOOR(78.97534,0.01) → The FLOOR function**will reduce the profit value up to**2**decimal places due to the significant value of**0.01****Output → 78.97**

- Drag down the
**Fill Handle**.

Eventually, you will be able to reduce the decimal places of the profits permanently.

**Read More:** **How to Fix Decimal Places in Excel (7 Simple Ways)**

## Practice Section

To practice by yourself, we have created a **Practice** section on the right side of each sheet.

## Conclusion

In this article, we have discussed various ways to **reduce decimal places permanently in Excel**. Hope these methods will help you a lot. If you have any further queries, then leave a comment below.

**Related Articles**

**How to Change Decimal Separator in Excel (7 Quick Methods)****How to Convert Decimal Time to Hours and Minutes in Excel****Converting Time to Decimals in Excel (4 Examples)****How to Stop Excel from Rounding Up Decimals (4 Easy Methods)****Add Decimals in Excel (3 Easy Ways)****How to Convert Decimal to Time Over 24 Hours in Excel (2 Quick Methods)**