How to Remove Decimal Places in Excel (5 Easy Methods)

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.

πŸ“Œ Steps

  • First, enter the following formula in cell C5 as shown below.
=INT(B5)
  • 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.πŸ‘‡

Remove Decimal Places with Excel INT Function

Read More: How to Fix Decimal Places in Excel (7 Simple Ways)


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.

πŸ“Œ Steps

  • Firstly, enter the following formula in cell C5 as shown below.
=TRUNC(B5,2)
  • Secondly, use the Fill Handle icon to do the same with other cell values.

After that, you get the desired results as follows.πŸ‘‡

Remove Decimal Places with Excel TRUNC Function

  • If you want to remove all the decimal places using this function, just remove the β€˜2’ argument from the formula.

Read More: How to Reduce Decimals in Excel (10 Easy Methods)


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.

πŸ“Œ Steps

  • Enter the formula given below in cell C5.
=ROUNDDOWN(B5,2)
  • Then, copy this formula down using the Fill Handle icon.

After that, you will get the same results as obtained in the earlier methods.πŸ‘‡

Remove Decimal Places with ROUNDDOWN Function

  • Now, replace the β€˜2’ argument with a β€˜0’ in the formula to convert the numbers to integers.

Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)


Similar Readings


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.

πŸ“Œ Steps

  • Firstly, apply the following formula in cell C5.
=FLOOR(B5,0.01)
  • Secondly, copy the formula to the cells below using the Fill Handle icon.

After that, you will get the following result.πŸ‘‡

Remove Decimal Places with Excel FLOOR Function

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

Read More: How to Remove Decimals Without Rounding in Excel (4 Suitable Ways)


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.

πŸ“Œ Steps

  • First, enter the formula given below in cell C5.
=FLOOR.MATH(B5,0.01)
  • Next, apply this formula to the cells below using the Fill Handle icon.

After that, you will get the results shown below.πŸ‘‡

Remove Decimal Places with Excel FLOOR.MATH Function

  • Finally, you can remove the β€˜0.01’ argument to remove all the decimal places from the numbers.

Read More: Excel 2 Decimal Places without Rounding (4 Efficient Ways)


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.

Conclusion

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.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo