Tanjima Hossain
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.
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.
