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.

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.

how to remove decimals in Excel without rounding

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.

how to remove decimals in Excel without rounding

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.

TRUNC function

➤ Press ENTER and drag down the Fill Handle tool.

TRUNC function

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

TRUNC function

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.

how to remove decimals in Excel without rounding

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.

how to remove decimals in Excel without rounding

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.

INT function

➤ Press ENTER and drag down the Fill Handle tool.

INT function

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

how to remove decimals in Excel without rounding

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

INT function

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


Similar Readings


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.

how to remove decimals in Excel without rounding

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.

FLOOR function

➤ Press ENTER and drag down the Fill Handle tool.

FLOOR function

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

FLOOR function

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

=FLOOR(D4,-1)

how to remove decimals in Excel without rounding

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.

FLOOR.MATH function

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.

how to remove decimals in Excel without rounding

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.

ROUNDDOWN function

➤ Press ENTER and drag down the Fill Handle tool.

ROUNDDOWN function

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

ROUNDDOWN function

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

how to remove decimals in Excel without rounding

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.

Practice


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

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo