This article illustrates five different ways to remove decimal places in excel. Sometimes, you may have redundant decimal digits in your dataset. For example, assume you are dealing with numbers in millimeter units in your dataset. Then you may say that the number 4.570462 has some unnecessary decimal places. Only the digits up to 2 decimal places are significant. Though not always, this is usually the case.
So, how can you remove those digits after the 2nd decimal place? Follow the article to learn how to do that in various ways. You will also learn how to remove all the decimal places too.
Download Practice Workbook
You can download the practice workbook from the download button below.
5 Ways to Remove Decimal Places in Excel
We will use the following dataset to illustrate the methods. So, let’s start!
1. Remove Decimal Places with Excel INT Function
If you need to remove all the decimal places, use the INT function in excel. Follow the steps below to do that.
- First, enter the following formula in cell C5 as shown below.
- Then, double click on the Fill Handle icon or drag it down to the cells below. It will copy the formula down below.
After that, you will see the following result.👇
2. Remove Decimal Places with Excel TRUNC Function
Now, what if you need to keep the first two decimal digits? Don’t worry. You can use the TRUNC function in excel for that. Follow the steps below to see how to use this function in the formula.
- Firstly, enter the following formula in cell C5 as shown below.
- Secondly, use the Fill Handle icon to do the same with other cell values.
After that, you get the desired results as follows.👇
- If you want to remove all the decimal places using this function, just remove the ‘2’ argument from the formula.
3. Truncate Decimal Places with ROUNDDOWN Function
You can also use the ROUNDDOWN function in excel to get the same results. Follow the steps below to learn how to do that.
- Enter the formula given below in cell C5.
- Then, copy this formula down using the Fill Handle icon.
After that, you will get the same results as obtained in the earlier methods.👇
- Now, replace the ‘2’ argument with a ‘0’ in the formula to convert the numbers to integers.
- Convert Decimal to Days Hours and Minutes in Excel (3 Methods)
- How to Insert Dot between Numbers in Excel (3 Ways)
- Set Decimal Places in Excel with Formula (5 Effective Ways)
- How to Convert Hours to Decimal in Excel (3 Easy Methods)
4. Remove Decimal Places with Excel FLOOR Function
The FLOOR function in excel also allows us to remove decimal places from numbers. Follow the steps below to see how to use this function in that regard.
- Firstly, apply the following formula in cell C5.
- Secondly, copy the formula to the cells below using the Fill Handle icon.
After that, you will get the following result.👇
- Now, do you want to remove the digits only after the 3rd decimal place? Then, replace the ‘0.01’ argument with a ‘0.001’. Moreover, you can use a ‘1’ instead to remove all of them.
5. Apply Excel FLOOR.MATH Function
Alternatively, you can use the FLOOR.MATH function for the same results. Follow the steps below to do that.
- First, enter the formula given below in cell C5.
- Next, apply this formula to the cells below using the Fill Handle icon.
After that, you will get the results shown below.👇
- Finally, you can remove the ‘0.01’ argument to remove all the decimal places from the numbers.
Things to Remember
- You need to copy the converted numbers and paste them as values to use them as such.
- You need to use the proper arguments in the formulas to get the results as required.
Now you know the five different ways to remove decimal places in excel. Did it help you to solve your problem? Which method did you find more convenient to use? Do you have any more queries or suggestions? Please let us know in the comment section below. Don’t forget to visit our ExcelDemy blog to explore more articles featuring excel tips and tricks and other problems and solutions.