How to Remove Decimals in Excel (13 Easy Ways)

If the numbers of your dataset have decimals, you may want to remove them to make the dataset look simple. Removing decimals is quite easy and you can do it in Excel in multiple ways. In this article, I’ll show you 13 ways to remove decimals in Excel.

Consider the following dataset, here we have the conversation of different amounts of different currencies into USD. Now we will remove the decimals from the Total USD column.

dataset

Download Practice Workbook

13 Ways to Remove Decimals in Excel

1. Remove Decimals with INT function

The INT function rounds the number down to the nearest integer. So we can get the integer part of a number which has no decimal points by applying the INT function. Type the following formula to an empty cell (E5),

=INT(D5)

Here, the INT function will return the integer part of the number of cell D5 in cell E5.

INT

Press ENTER and you’ll get the number without decimals.

REMOVE DECIMALS

To apply the same formula in all other cells, just drag the cell E5.

APPLY ALL

2. TRUNC Function to Remove decimals

The TRUNC function simply truncates the decimal part of a number and returns the integer part. To apply this function for removing decimals type the following formula in cell E5,

=TRUNC(D5)

Here, the function will truncate the decimal part of the number in cell D5 and will return the integer part in cell E5.

TRUNC

Press ENTER and you’ll get the number without decimals in cell E5.

REMOVE DECIMALS

To apply the same formula in all other cells, just drag the cell E5.

REMOVED DECIMALS

3. ROUND Function

The ROUND function rounds the number to a given number of digits. To remove the decimal completely, we need to put 0 as the given number of digits. If the decimal part is bigger than 0.5 it will round up the number and if the decimal part is smaller or equal to 0.5, it will round down the number.

Let’s start removing decimals using this function, to do so, type the following formula in cell E5,

=ROUND(D5,0)

Here, the function will round the number of cell D5 without any decimals and will give the value in cell E5.

ROUND

Press ENTER to get the number without decimals.

ROUND

Here, the decimal part was .80 (bigger than .5) so it rounded up the value. Finally, Drag the cell E5, to get the number without decimals for all other cells.

REMOVE DECIMALS

4. ROUNDDOWN Function

The ROUNDDOWN function round downs the number down to a given number of digits. If we give 0 as the given number, the function will remove the decimal part from the number. Type the following formula in cell E5,

=ROUNDDOWN(D5,0)

Here, the ROUNDDOWN function will round down the number of cell D5. 0 indicates that there will be no decimal parts.

REMOVE DECIMALS

Press ENTER to get the number without decimals in cell E5.

ROUNDDOWN

Drag cell E5 to remove decimals from all the numbers.

REMOVE DECIMALS

5. ROUNDUP Function

The ROUNDUP function will round the number up to a given number of digits. If we give 0 as the given number, the function will remove the decimal part from the number. Type the following formula in cell E5,

=ROUNDUP(D5,0)

Here, the ROUNDUP function will round up the number of cell D5. 0 indicates that there will be no decimal parts.

ROUNDUP

Press ENTER and you’ll get the number without decimals in cell E5.

ROUNDUP

To apply the same formula in all other cells, just drag the cell E5.

REMOVE DECIMALS

6. MROUND Function

The MROUND function rounds the number to a specified multiple. So, if we select the multiple 1, the function will remove the decimals. Type the following formula in cell E5,

=MROUND(D5,1)

Here, the MROUND function will round the number of cell D5 to a multiple of 1 in cell E5.

MROUND

Press ENTER and you will get the round figure of the number without decimals in cell E5.

MROUND

At last, drag the cell E5 to get the value in all other cells.

REMOVE DECIMALS

7. ODD Function to Remove Decimals

The ODD function returns the next odd number of the selected number. So we can remove decimals by using the ODD function. Type the formula in cell E5,

=ODD(D5)

Here, the function will return the next odd number of the number of cell D5.

ODD

Press ENTER to get the number without decimals in cell E5.

ODD

At last, drag the cell E5 to get the value in all other cells.

REMOVE DECIMALS


Similar Readings:


8. EVEN Function to Remove Decimals

The EVEN function returns the next even number of the selected number. So we can remove decimals by using the EVEN function. Type the formula in cell E5,

=EVEN(D5)

Here, the function will return the next even number of the number of cell D5.

EVEN

Press ENTER and you’ll get the number without decimals in cell E5.

EVEN

To apply the same formula in all other cells, just drag the cell E5.

REMOVE DECIMALS

9. Remove Decimals with CEILING Function

The CEILING function rounds a number up to the nearest multiple of significance. So if we give 1 as the significance, the function will remove the decimals from the number. Type the formula in cell E5,

=CEILING(D5,1)

Here the CEILING function will round up the number of cell D5 to a multiple of 1.

CEILING

Press ENTER and you’ll get the number without decimals.

CEILING

At last drag the cell E5 to apply the same formula in all other cells.

REMOVE DECIMALS

10. Remove Decimals with CEILING.MATH Function

The CEILING.MATH function automatically sets the significance as 1. So we don’t need to define the significance to remove the decimals in the CEILING.MATH function. Type the formula in cell E5,

=CEILING.MATH(D5)

It will round up the number to the next integer. As a result, the decimals will be removed

CEILING.MATH

Press ENTER and you’ll get the number without decimals.

CEILING MATH

To apply the same formula in all other cells, just drag the cell E5.

REMOVE DECIMALS

11. FLOOR Functions to Remove Decimals

The FLOOR function rounds a number down to the nearest multiple of significance. So if we give 1 as the significance, the function will remove the decimals from the number. Type the formula in cell E5,

=FLOOR(D5,1)

Here the FLOOR function will round down the number of cell D5 to a multiple of 1.

FLOOR

Press ENTER and you’ll get the number without decimals in cell E5.

FLOOR

To apply the same formula in all other cells, just drag the cell E5.

REMOVE DECIMALS

12. FLOOR.MATH Functions to Remove Decimals

The FLOOR.MATH function automatically sets the significance as 1. So we don’t need to define the significance to remove the decimals in the FLOOR.MATH function. Type the formula in cell E5,

=FLOOR.MATH(D5)

It will round down the number to the previous integer. As a result, the decimals will be removed

FLOOR.MATH

Press ENTER to get the number without decimals in cell E5.

FLOOR MATH

Finally, Drag the cell E5, to get the number without decimals for all other cells.

REMOVE DECIMALS

13. Format Cells to Remove Decimals

You can easily remove decimals from the Format cells Ribbon. First, select the cells from where you want to remove decimals. After that, you just need to go to the Home tab and keep clicking on the Decrease Decimals sign until the decimals are completely removed.

REMOVE DECIMALS

You can also use the format cells tool to remove decimals. Select the cell from where you want to remove decimals and right click. A drop down menu will appear, from there select Format Cells.

FORMAT CELLS

After that, the Format Cells box will appear. Here, go to the Number tab, enter 0 in the Decimals places box and click on OK.

FORMAT CELLS

Now you can see all the decimals from your selected cells are removed.

REMOVE DECIMALS

Conclusion

You can remove decimals in Excel by any of the methods which have been described in this article. If you feel any type of confusion, please leave a comment and give me a chance to remove your confusion.


Further Readings

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo