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.

## How to Remove Decimals Without Rounding in Excel: 4 Ways

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.

__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.

__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: **How to Get 2 Decimal Places Without Rounding in Excel

__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.

## 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.

**Download Workbook**

## 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.

## Related Articles

- How to Round up Decimals in Excel
- How to Round Up to 2 Decimal Places in Excel
- Excel VBA: Round to 2 Decimal Places
- How to Set Decimal Places in Excel with Formula
- How to Remove Decimals in Excel with Rounding
- How to Stop Rounding in Excel
- How to Stop Excel from Rounding Large Numbers

- How to Stop Excel from Rounding Up Decimals

**<< Go Back to Stop Rounding | Rounding in Excel | Number Format | Learn Excel**