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

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

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

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

Input 0 as the amount of decimal digit demanded

Type close bracket sign
 Type Enter

The process is done!
Method 2  FLOOR

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

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

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

Input 1 as the multiplication factor demanded

Type close bracket sign
 Type Enter

The process is done!
Method 3  INT

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

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

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

Type close bracket sign
 Type Enter

The process is done!
Method 4  TRUNC

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

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

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

Type close bracket sign
 Type Enter

The process is done!
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 graycolored cells.Form whole numbers by removing the decimals from each of the numbers in the exercise file using:
 INT
 FLOOR
 ROUNDDOWN
 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.