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.

**Table of Contents**hide

## 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**.

Press **ENTER **and youâ€™ll get the number without decimals.

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

### 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**.

Press **ENTER **and youâ€™ll get the number without decimals in cell **E5**.

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

### 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**.

Press **ENTER **to get the number without decimals.

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.

### 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.

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

Drag cell **E5** to remove decimals from all the numbers.

### 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.

Press **ENTER **and youâ€™ll get the number without decimals in cell **E5**.

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

### 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**.

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

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

### 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**.

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

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

**Similar Readings:**

**How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)****Remove Numbers from a Cell in Excel (7 Effective Ways)****How to Remove Data Validation in Excel (5 Ways)**

### 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**.

Press **ENTER **and youâ€™ll get the number without decimals in cell **E5**.

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

### 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.

Press **ENTER **and youâ€™ll get the number without decimals.

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

### 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

Press **ENTER **and youâ€™ll get the number without decimals.

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

### 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.

Press **ENTER **and youâ€™ll get the number without decimals in cell **E5**.

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

### 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

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

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

### 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.

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**.

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**.

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

## 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.