How to Remove Decimals Without Rounding in Excel (4 Suitable Ways)

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.

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.

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.

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.

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

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.

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