# How to Remove Decimals Without Rounding in Excel (4 Methods)

## Dataset Overview

We’ll use a dataset containing records of distances and the required times for participants in a competition.

### Method 1 – Using the TRUNC Function

• Add an extra column called Time (sec) without Decimal.

• In cell E4, enter the following formula:
`=TRUNC(D4,0)`

Here, D4 represents the time value with decimals, and 0 specifies zero decimal places. Adjust the number (e.g., 1 or 2) if you need a specific decimal precision.

• Press ENTER and drag down the Fill Handle to apply the formula to other cells.

This method removes decimals without altering the whole numbers.

To demonstrate the results for the negative decimals we are assuming negative time values (only used for an example).
We can see that the TRUNC function also works for negative decimal values.

### Method 2 – Using the INT Function

We have the same dataset.

• In cell E4, insert the formula:
`=INT(D4)`

D4 represents the time value with decimals. The INT function converts decimal values to integers without rounding.

• Press ENTER and drag down the Fill Handle.

This method provides the original time values without decimals.

The INT function does not work accurately for negative values as it rounds down.

### Method 3 – Using the FLOOR Function

• In cell E4, insert the formula:
`=FLOOR(D4,1)`

D4 is the time value with decimals. The significance of 1 ensures the result is a whole number multiple of 1.

• Press ENTER and drag down the Fill Handle.

This method provides the original time values without decimals.

For negative decimals, insert:

`=FLOOR(D4,-1)`

You can also use the FLOOR.MATH function instead of the Floor function to get the same results:

`=FLOOR.MATH(D4)`

### Method 4 – Rounding Down with the ROUNDDOWN Function

• In cell E4, enter:
`=ROUNDDOWN(D4,0)`
• Adjust the second argument (e.g., 1 or 2) for specific decimal places.

• Press ENTER and drag down the Fill Handle.

The ROUNDDOWN function works similarly for negative decimal values:

## Practice Section

For doing practice by yourself we have provided a Practice section in a sheet labelled Practice.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF