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; you can do it in Excel in multiple ways. In this article, I’ll show you 13 ways to remove decimals in Excel.

Remove decimals in Excel


Download Practice Workbook

You are welcome to download the practice workbook from the link below.


13 Easy 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 to remove decimals from numbers


1. Remove Decimals with INT Function in Excel

The INT function rounds the number down to the nearest integer. So, we can get the integer part of a number that has no decimal points by applying the INT function.

Steps:

  • Firstly, type the following formula to an empty cell (F5).
=INT(E5)
  • Then, press Enter and you’ll get the number without decimals.
  • After that, apply the same formula in all other cells, just drag the cell F5.

Removing Decimals with INT Function in Excel

  • Thus, you can remove decimals using the INT function.

Results found after using INT function

Here, the INT function returns the integer parts of the numbers of Column E in Column F.

2. Use TRUNC Function to Remove Decimals

The TRUNC function simply truncates the decimal part of a number and returns the integer part.

Steps:

  • In the beginning, to apply this function for removing decimals type the following formula in Cell F5.
=TRUNC(E5)
  • Now, press Enter and drag down the Fill Handle tool to copy the formula for the rest of the cells.

Using TRUNC Function to Remove Decimals in Excel

  • Thus, you can remove decimals using the TRUNC function.

Results found after using TRUNC function

Here, the function truncates the decimal part of the number in Cell E5 and will return the integer part in Cell F5.

3. Apply ROUND Function to Eliminate Decimals in Excel

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.

Steps:

  • To start with, type the following formula in Cell F5.
=ROUND(E5,0)
  • Press ENTER to get the number without decimals.
  • Here, the decimal part was .80 (bigger than .5) so it rounded up the value.
  • Lastly, drag the Cell F5, to get the number without decimals for all other cells.

Using ROUND Function to Remove Decimals in Excel

  • Finally, we will get all the rounded numbers.

Results found after using ROUND function

In the formula, the function rounds the number of Cell F5 without any decimals and will give the value in Cell F5.

4. Remove Decimals Using Excel 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.

Steps:

  • Firstly, type the following formula to an empty cell F5.
=ROUNDDOWN(E5,0)
  • Then, press Enter and you’ll get the number without decimals.
  • After that, apply the same formula in all other cells, just drag the cell F5.

Using ROUNDDOWN Function to Remove Decimals

  • Finally, we will get all the rounded numbers.

Results found after using ROUNDDOWN function

Here, the ROUNDDOWN function rounds down the number of Cell E5. 0 indicates that there will be no decimal parts.

5. Employ ROUNDUP Function to Remove Decimals in Excel

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.

Steps:

  • In the beginning, to apply this function for removing decimals type the following formula in Cell F5.
=ROUNDUP(E5,0)
  • Now, press Enter and drag down the Fill Handle tool to copy the formula for the rest of the cells.

Employing ROUNDUP Function to Remove Decimals in Excel

  • Thus, you can remove decimals using the ROUNDUP function.

Results found after using ROUNDUP function

The ROUNDUP function rounds up the number of Cell E5. 0 indicates that there will be no decimal parts.

6. Use MROUND Function to Eliminate Decimals from Number

The MROUND function rounds the number to a specified multiple. So, if we select the multiple 1, the function will remove the decimals.

Steps:

  • To start with, insert the following formula in Cell F5.
=MROUND(E5,1)
  • After that, press Enter and you will get the round figure of the number without decimals in Cell F5.
  • Lastly, drag down Cell F5 to get the value in all other cells.

Using MROUND Function to Remove Decimals

  • Finally, we will get all the rounded numbers.

Results found after using MBOUND function

Here, the MROUND function rounds the number of Cell E5 to a multiple of 1 in Cell F5.

7. Ultilize ODD Function to Round Number to Nearest Odd Number Removing Decimals

The ODD function returns the next odd number of the selected number. So, we can remove decimals by using the ODD function.

Steps:

  • In the beginning, to apply this function for removing decimals type the following formula in Cell F5.
=ODD(E5)
  • Now, press Enter and drag down the Fill Handle tool to copy the formula for the rest of the cells.

Utilizing ODD Function to Remove Decimals

  • Thus, all the numbers will be rounded to the nearest odd number removing decimals.

Results found after using ODD function

In the formula, the function returns the next odd number of the number of Cell E5.

Similar Readings:


8. Round Number to Nearest Even Number Removing Decimals Using EVEN Function

The EVEN function returns the next even number of the selected number. So, we can remove decimals by using the EVEN function.

Steps:

  • Type the formula in Cell F5.
=EVEN(E5)
  • Then, press Enter and you’ll get the number without decimals.
  • After that, apply the same formula in all other cells, just drag the Cell F5.

Using EVEN Function to Remove Decimals in Excel

  • Thus, all the numbers will be rounded to the nearest even number removing decimals.

Results found after using EVEN function

Here, the function will return the next even number of the number of Cell E5.

9. Remove Decimals with CEILING Function in Excel

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.

Steps:

  • Firstly, type the following formula to an empty Cell F5.
=CEILING(E5,1)
  • Secondly, press Enter and you’ll get the number without decimals.
  • After that, apply the same formula in all other cells, just drag Cell F5.

Removing Decimals with CEILING Function

  • Thus, you can remove decimals using the CEILING function.

Results found after using CEILING function

In the formula, the CEILING function will round up the number of Cell E5 to a multiple of 1.

10. Apply CEILING.MATH Function to Remove Decimals

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.

Steps:

  • In the beginning, to apply this function for removing decimals type the following formula in Cell F5.
=CEILING.MATH(E5)
  • Now, press Enter and drag down the Fill Handle tool to copy the formula for the rest of the cells.

Apply CEILING.MATH Function to Remove Decimals in Excel

  • Thus, you can remove decimals using CEILING.MATH function.

Results found after using CEILING.MATH function

The formula rounds up the number to the next integer. As a result, the decimals are removed.

11. Remove Decimals Using FLOOR Function in Excel

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.

Steps:

  • Firstly, type the following formula to an empty Cell F5.
=FLOOR(E5,1)
  • Then, press Enter and you’ll get the number without decimals.
  • After that, apply the same formula in all other cells, just drag the Cell F5.

Removing Decimals Using FLOOR Function in Excel

  • Finally, we will get all the rounded numbers.

Results found after using FLOOR function

Here, the FLOOR function rounds down the number of Cell D5 to a multiple of 1.

12. Use FLOOR.MATH Function to Eliminate Decimals in Excel

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.

Steps:

  • To start with, insert the following formula in Cell F5.
=FLOOR.MATH(E5)
  • After that, press Enter and you will get the round figure of the number without decimals in Cell F5.
  • Lastly, drag down Cell F5 to get the value in all other cells.

Using FLOOR.MATH Function to Eliminate Decimals in Excel

  • Now, you will get all the numbers without decimals.

Results found after using FLOOR.MATH function

The FLOOR function rounds down the number to the previous integer. As a result, the decimals are removed.

13. Format Cells to Remove Decimals in Excel

In the last method, we will show you how you can remove decimals by formatting Cells in Excel. You can do it using the ribbon or right-clicking on the cell and then opening the Format Cells box.

Steps:

  • Firstly, 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.

Formatting Cells Using Ribbon to Remove Decimals

  • However, you can also use the format cells tool to remove decimals.
  • Next, select the cell from where you want to remove decimals and right-click.
  • Now, a drop-down menu will appear, from there select Format Cells.

Opening Format Cells box to remove decimals

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

Changing Format in Format Cells Box

 

  • Finally, you can see all the decimals from your selected cells are removed.

Results found after formatting cells


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


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. And visit ExcelDemy for many more articles like this. Thank you!


Further Readings

Prantick Bala

Prantick Bala

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