How to Remove Decimals in Excel (13 Methods)

 

 

In the sample dataset, there are a variety of different currencies, quantities and their exchange rate to USD. The decimals need to be removed from the Total USD column.

Dataset to remove decimals from numbers


Method 1 – Using INT Function to Remove Decimals in Excel

The INT function rounds the number down to the nearest integer.

Steps:

  • Enter the following formula in an empty cell (F5).
=INT(E5)
  • Press Enter.
  • Apply the same formula to the rest of the column by dragging the fill handle down.

Removing Decimals with INT Function in Excel

 

Results found after using INT function

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

Read More: How to Reduce Decimals in Excel


Method 2 – Removing Decimals with Excel TRUNC Function

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

Steps:

  • Paste the following formula in Cell F5.
=TRUNC(E5)
  • Press Enter and drag the Fill Handle down to copy the formula to the rest of the cells.

Using TRUNC Function to Remove Decimals in Excel

 

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.

Read More: How to Remove Decimals in Excel Formula Bar


Method 3 – Applying 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.

Steps:

  • Paste the following formula in Cell F5.
=ROUND(E5,0)
  • Press ENTER.
  • Here, the number after the decimal was .80 (ie, bigger than .5) so the formula rounded up the value.
  • Apply the same formula to the rest of the column by dragging the fill handle down.

Using ROUND Function to Remove Decimals in Excel

 

Results found after using ROUND function

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

Read More: How to Reduce Decimal Places Permanently in Excel


Method 4 – Remove Decimals Using Excel ROUNDDOWN Function

The ROUNDDOWN function rounds downs the number to a given number of digits. If 0 is the given number, the function will remove the decimal part from the number.

Steps:

  • Paste the following formula to an empty cell F5.
=ROUNDDOWN(E5,0)
  • Press Enter.
  • Apply the same formula to the rest of the column by dragging the fill handle down.

Using ROUNDDOWN Function to Remove Decimals

 

Results found after using ROUNDDOWN function

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

Method 5 – Applying ROUNDUP Function to Remove Decimals in Excel

The ROUNDUP function will round the number up to a given number of digits.

Steps:

  • Enter the following formula in Cell F5.
=ROUNDUP(E5,0)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Employing ROUNDUP Function to Remove Decimals in Excel

 

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.

Method 6 – Using MROUND Function to Delete Decimals from Number

The MROUND function rounds the number to a specified multiple. If 1 is selected the function will remove the decimals.

Steps:

  • Insert the following formula in Cell F5.
=MROUND(E5,1)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Using MROUND Function to Remove Decimals

 

Results found after using MBOUND function

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

Method 7 – Remove Decimal and Round Numbers to the Nearest Odd Number 

The ODD function returns the next odd number of the selected number.

Steps:

  • Enter the following formula in Cell F5.
=ODD(E5)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Utilizing ODD Function to Remove Decimals

 

Results found after using ODD function

The function returns the next odd number of the number of Cell E5.

Method 8 – Rounding Number to the Nearest Even Number and Removing Decimals

The EVEN function returns the next even number of the selected number.

Steps:

  • Enter the below formula in Cell F5.
=EVEN(E5)

 

  • Press Enter and drag the Fill Handle tool down to copy the formula.

Using EVEN Function to Remove Decimals in Excel

 

Results found after using EVEN function

The function will return the next even number of the number of Cell E5.


Method 9 – Using CEILING Function to Remove Decimals in Excel

The CEILING function rounds a number up to the nearest multiple of significance.

Steps:

  • Enter the following formula into Cell F5.
=CEILING(E5,1)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Removing Decimals with CEILING Function

 

Results found after using CEILING function

The CEILING function will round up the number of Cell E5 to a multiple of 1.

Method 10 – Applying Excel CEILING.MATH Function to Remove Decimals

The CEILING.MATH function automatically sets the significance as 1.

Steps:

  • Enter the following formula in Cell F5.
=CEILING.MATH(E5)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Apply CEILING.MATH Function to Remove Decimals in Excel

 

Results found after using CEILING.MATH function

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

Method 11 – Removing Decimals Using the FLOOR Function in Excel

The FLOOR function rounds a number down to the nearest multiple of significance.

Steps:

  • Enter the following formula in Cell F5.
=FLOOR(E5,1)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Removing Decimals Using FLOOR Function in Excel

 

Results found after using FLOOR function

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

Method 12 – Using FLOOR.MATH Function to Delete Decimals in Excel

The FLOOR.MATH function automatically sets the significance as 1.

Steps:

  • Enter the following formula in Cell F5.
=FLOOR.MATH(E5)
  • Press Enter and drag the Fill Handle tool down to copy the formula.

Using FLOOR.MATH Function to Eliminate Decimals in Excel

 

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.

Method 13 – Applying Excel Format Cells Option to Remove Decimals

 

Steps:

  • Select the relevant cells.
  • Go to the Home tab and click on the Number option.
  • Click on the Decrease Decimals sign until the decimals are completely removed.

Formatting Cells Using Ribbon to Remove Decimals

  • You can also use the format cells tool to remove decimals.
  • Select the cell where the decimals are to be removed and right-click.
  • From the drop-down menu select Format Cells.

Opening Format Cells box to remove decimals

  • The Format Cells box will appear.
  • Go to the Number tab and enter 0 in the Decimals places box.
  • Click on OK.

Changing Format in Format Cells Box

 

  • All the decimals from the selected cells have been removed.

Results found after formatting cells


Download Practice Workbook


Related Articles


<< Go Back to Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo