How to Remove Decimals in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Remove Decimals in Excel



In this tutorial, you will learn how to remove decimals in excel. How to remove digits after decimal in excel is something that you should know. Especially if you often deal with numeric data processing in your spreadsheet file.

How to remove decimals in excel which will be explained is different from how to round numbers. If what you need is the rounding process, then please see this tutorial instead.


Why do We Need to Learn How to Remove Decimal Value in Excel?


In doing numeric data processing, sometimes we need to remove the numbers behind the point. This is needed when we prefer whole numbers in our processing process. Or probably this is needed in terms of showing the right results of your digits processing. When the process is needed, then we should already have an understanding of how to do it. The lack of our understanding will make our data processing becomes not optimal.

As an example of the removal need in our work, imagine if we process sales data for our company. In the process, maybe we analyze variables like product sales average, salespeople average, and the others. In some of these variables, there is a need for whole numbers either in the results or process. For example, the product sales or salespeople number that cannot be decimal. If there is a need like this, then we need to understand how to process the whole numbers. This is so our analysis result won’t be wrong.

There are two ways to get a whole number from decimal: rounding and removal of the decimals. It is better you understand the two of them so you can use the appropriate process when you need it.

What is explained here, by the way, is the second way. By understanding how to remove decimals in excel without rounding, it should be much easier to process your numbers correctly.


What is How to Remove Decimals in Excel?


How to remove decimals in excel is a function to get whole numbers from decimals by removing all digits behind point. This might be needed if you do numeric data processing in your spreadsheet file.


How to Remove Number After Decimal in Excel?


The following will explain how to remove decimals in excel in your spreadsheet file. Four formulas can help you which are ROUNDDOWN, FLOOR, INT, and TRUNC. The explanation will be given one by one about how to use each of the formulas to do the removal process.


Method 1 - ROUNDDOWN


  1. Type equal sign ( = ) in the cell where you want to put the result in

    How to Remove Decimals in Excel - Screenshot of Step 1-1

  2. Type ROUNDDOWN (can be with large and small letters) and open bracket sign after =

    How to Remove Decimals in Excel - Screenshot of Step 1-2

  3. Input number / cell coordinate where the number which you want to process is after open bracket sign followed by a comma sign ( , )

    How to Remove Decimals in Excel - Screenshot of Step 1-3

  4. Input 0 as the amount of decimal digit demanded

    How to Remove Decimals in Excel - Screenshot of Step 1-4

  5. Type close bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 1-5

  6. Type Enter
  7. The process is done!

    How to Remove Decimals in Excel - Screenshot of Step 1-7




Method 2 - FLOOR


  1. Type equal sign ( = ) in the cell where you want to put the result in

    How to Remove Decimals in Excel - Screenshot of Step 2-1

  2. Type FLOOR (can be with large and small letters) and open bracket sign after =

    How to Remove Decimals in Excel - Screenshot of Step 2-2

  3. Input number / cell coordinate where the number which you want to process is after open bracket sign followed by a comma sign ( , )

    How to Remove Decimals in Excel - Screenshot of Step 2-3

  4. Input 1 as the multiplication factor demanded

    How to Remove Decimals in Excel - Screenshot of Step 2-4

  5. Type close bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 2-5

  6. Type Enter
  7. The process is done!

    How to Remove Decimals in Excel - Screenshot of Step 2-7




Method 3 - INT


  1. Type equal sign ( = ) in the cell where you want to put the result in

    How to Remove Decimals in Excel - Screenshot of Step 3-1

  2. Type INT (can be with large and small letters) and open bracket sign after =

    How to Remove Decimals in Excel - Screenshot of Step 3-2

  3. Input number / cell coordinate where the number which you want to process is after open bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 3-3

  4. Type close bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 3-4

  5. Type Enter
  6. The process is done!

    How to Remove Decimals in Excel - Screenshot of Step 3-6




Method 4 - TRUNC


  1. Type equal sign ( = ) in the cell where you want to put the result in

    How to Remove Decimals in Excel - Screenshot of Step 4-1

  2. Type TRUNC (can be with large and small letters) and open bracket sign after =

    How to Remove Decimals in Excel - Screenshot of Step 4-2

  3. Input number / cell coordinate where the number which you want to process is after open bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 4-3

  4. Type close bracket sign

    How to Remove Decimals in Excel - Screenshot of Step 4-4

  5. Type Enter
  6. The process is done!

    How to Remove Decimals in Excel - Screenshot of Step 4-6



Exercise


After you know how to remove decimals in excel using the four methods, now is the time to do an exercise. This is so you can sharpen your understanding of how to remove decimals in excel.

Download the exercise file below and do the instruction. Download the answer key file if you have done the exercise and want to check your answer. Or probably if you are confused about how to finish the exercise!

Link of the exercise file:
Download here

Instruction:

Answer on the appropriate number row in each of the gray-colored cells.

Form whole numbers by removing the decimals from each of the numbers in the exercise file using:
  1. INT
  2. FLOOR
  3. ROUNDDOWN
  4. TRUNC

Link of the answer key file:
Download here


Additional Note


Make sure your need for the whole number is through rounding or decimal digits removal. The mistake in the choice can seriously affect your numeric data processing results.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert