If you are looking for ways to **remove decimals without rounding** in Excel, then you will find this article useful. Normally, when we try to **remove the decimals** in Excel it will round the number but sometimes, we may want the exact whole number only. To know the ways of removing decimals without rounding the number, letâ€™s dive into the main article.

**Table of Contents**hide

## Download Workbook

## 4 Ways to Remove Decimals Without Rounding in Excel

Here, we have the following dataset containing the records of the distances and the required times of some of the participants in a competition. By using the following methods, we will try to remove the decimals of the times without changing the whole number.

We have used *Microsoft Excel 365* version here; you can use any other version according to your convenience.

__Method-01__: Remove Decimals without Rounding Using TRUNC Function in Excel

Here, we have some time values with decimals, and using **the** **TRUNC function** we will remove the decimals without rounding or changing the whole time values. To have the new times without decimals we have added an extra column; **Time (sec) without Decimal**.

** Steps**:

âž¤ Type the following formula in cell

**E4**.

`=TRUNC(D4,0)`

Here, **D4 **is the time value with decimals, and **0 **is indicating **zero **values after the decimal point. So, if you want to have **1 **or **2 **or **n **decimal places in a value then just use **1 **or **2 **or **n **instead of **0 **in this formula.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

After that, you will have the whole numbers only by removing the decimals and without any change to the resulting numbers.

To demonstrate the results for the negative decimals we are assuming the negative time values also, which is practically impossible.

Here, we can see that the **TRUNC function **similarly works for negative decimal values also.

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

__Method-02__: Using INT Function in Excel to Remove Decimals Without Rounding

By using **the** **INT function** you can also extract the integer values by removing decimals from the time values.

** Steps**:

âž¤ Apply the following formula in cell

**E4**.

`=INT(D4)`

Here, **D4 **is the time required for ** Michael **with decimal values.

**INT**will convert the decimal values into an integer without rounding by removing the decimals.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Finally, you will have the times without any changing and decimals in the ** Time (sec) without Decimal**.

The **INT function **is not working properly for negative values as the whole numbers are being changed here.

**Read More: How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)**

**Similar Readings**

**Reduce Decimals in Excel (10 Easy Methods)****How to Insert Dot between Numbers in Excel (3 Ways)****Set Decimal Places in Excel with Formula (5 Effective Ways)****How to Remove Decimals in Excel with Rounding (10 Easy Methods)**

__Method-03__: Use of FLOOR Function to Remove Decimals Without Rounding

In this section, we are going to use **the FLOOR function** to convert the decimal time values to integers without rounding them.

** Steps**:

âž¤ Use the following formula in cell

**E4**.

`=FLOOR(D4,1)`

Here, **D4 **is the time value with decimals, and **1 **is the *significance *or the value to which the number is an integer multiple. By using **1 **as the significance we will get a resultant value of ** 1260 **which is the multiple of

**1**and the whole number of

**D4**.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Eventually, we will have the final original time values without any decimals.

For negative decimals, the significance value should be **-1**.

`=FLOOR(D4,-1)`

You can also use **the** **FLOOR.MATH function** instead of **the Floor function **to gain the same results as the previous one.

`=FLOOR.MATH(D4)`

Here, we donâ€™t have to put any value for significance if the value is **1**.

**Read More: Excel 2 Decimal Places without Rounding (4 Efficient Ways)**

__Method-04__: Remove Decimals without Rounding Using the ROUNDDOWN Function in Excel

**The ROUNDDOWN function** can also be used to take out the decimals from the following time values without reforming the integer times.

** Steps**:

âž¤ Type the following formula in cell

**E4**.

`=ROUNDDOWN(D4,0)`

Here, **D4 **is the decimal time value, and **0 **is indicating **zero **values after the decimal point. So, if you want to have **1 **or **2 **or **any other **decimal places in a value then just use **1 **or **2 **or **any other value **instead of **0 **in this formula.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

As a result, we are getting the whole time values extracted from the decimals without any reformation.

Here, we can see that the **ROUNDDOWN function **similarly works for negative decimal values also.

**Read More:Â ****Convert Decimal to Days Hours and Minutes in Excel (3 Methods)**

## Practice Section

For doing practice by yourself we have provided a** Practice** section like below in a sheet named **Practice**. Please do it by yourself.

## Conclusion

In this article, we tried to cover the ways to remove decimals in Excel without rounding. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.