How to Reduce Decimals in Excel (10 Easy Methods)

The article will show you 10 effective and easy methods on how to reduce decimals in Excel. Sometimes, you may have repeating decimals or irrational or transcendental numbers as results after your data calculation. In order to simplify those decimal numbers, you need to reduce the decimal part of them.

In the dataset, we have information about a company’s percentage of profit on different products.

how to reduce decimals in excel


Download Practice Workbook


10 Ways to Reduce Decimals in Excel

1. Applying Number Format Feature to Reduce Decimals in Excel

This section will show you how to reduce decimals from percentages by using a built-in command. Let’s go through the procedure below.

Steps:

  • First, make a column for reduced percentages and select the range E5:E11.
  • Go to Number Format >> Number

  • Type the following formula in cell E5.
=D5

how to reduce decimals in excel

  • Press the ENTER button and you will see the percentage in a reduced decimal

  • Use the Fill Handle to AutoFill the lower cells.

how to reduce decimals in excel

Thus you can reduce decimals by using the Excel built-in command.

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


2. Implementing Button from Number Format to Reduce Decimals in Excel

Another easy way to reduce decimals is to use the Decrease Decimal button in the Number ribbon. Please, read the description below.

Steps:

  • Select the range D5:D11 and put your cursor on the Decrease Decimal

  • Click on the button one or multiple times. You will see the percentages in reduced decimals.

how to reduce decimals in excel

By following this approach, you can easily reduce decimals from a number.

Read More: How to Change Decimals to Percentages in Excel (4 Easy Ways)


3. Inserting Excel ROUND Function to Reduce Decimals

Now we are going to use a formula to reduce decimals. The ROUND Function is very effective when we want to simplify a decimal number.

Steps:

  • Make a new column for reduced percentage and type the following formula in the cell E5.
=ROUND(D5,3)

Here, the ROUND Function leaves 3 numbers after the decimal point of the number in cell D5.

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

how to reduce decimals in excel

By following this approach, you can reduce decimals from a number in Excel using the ROUND Function.

Read More: How to Set Decimal Places in Excel with Formula (5 Effective Ways)


4. Applying Excel ROUNDDOWN Function to Reduce Decimals

We can also use the ROUNDDOWN Function to reduce decimals from the profit percentages of the products. Let’s go through the process below.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=ROUNDDOWN(D5,1)

how to reduce decimals in excel

Here, the ROUNDDOWN Function leaves 1 number after the decimal point of the number in cell D5 and rounds it down.

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

  • Use the Fill Handle to AutoFill the lower cells.

how to reduce decimals in excel

Thus you can reduce decimals from a number in Excel with the help of the ROUNDDOWN Function.

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


5. Implementing ROUNDUP Function to Reduce Decimals

There is another function that we can use to reduce decimals. The name of this function is the ROUNDUP function. Let’s go through the procedure below for a better understanding.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=ROUNDUP(D5,2)

Here, the ROUNDUP Function leaves 2 numbers after the decimal point of the number in cell D5 and rounds it up.

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

how to reduce decimals in excel

  • Use the Fill Handle to AutoFill the lower cells.

By following this approach, you can reduce decimals from a number in Excel using the ROUNDUP Function.

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


Similar Readings


6. Use of MROUND Function

We can also use the MROUND Function to reduce decimals from the profit percentages of the products. Let’s go through the process below.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=MROUND(D5*10,1)/10

how to reduce decimals in excel

Here, D5*10 will return 233.4531 and MROUND(D5*10,1) will return the nearest multiple of 1 to 233.4531 which is 233, as we set the multiple 1. We want 1 number after the decimal point so we divided the formula by 10..

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

  • Use the Fill Handle to AutoFill the lower cells.

how to reduce decimals in excel

Thus you can reduce decimals from a number in Excel using the MROUND Function.

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


7. Application of INT Function

Another function that we can use to reduce decimals is the INT Function. We want to keep 3 numbers after the decimal. Let’s go through the procedure below for better understanding.

Steps:

  • Make a new column for reduced percentage and type the following formula in the cell E5.
=INT(D5*1000)/1000

Here, the INT Function returns the whole part of D5*1000 which is 23345. We want  3 numbers after the decimal point so we divided the formula by 1000..

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

how to reduce decimals in excel

  • Use the Fill Handle to AutoFill the lower cells.

By following this approach, you can reduce decimals from a number in Excel with the help of the INT Function.


8. Implementing TRUNC Function to Reduce Decimals

Now we are going to use a function named TRUNC function to reduce decimals. Let’s go through the description below.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=TRUNC(D5,2)

how to reduce decimals in excel

Here, the TRUNC Function leaves 2 numbers after the decimal point of the number in cell D5, as we set [num_digits] to 2.

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

  • Use the Fill Handle to AutoFill the lower cells.

how to reduce decimals in excel

By following this approach, you can reduce decimals from a number in Excel using the TRUNC function.


9. Application of FLOOR and IF Functions

We can also use the combination of FLOOR and IF Functions to reduce decimals from the profit percentages of the products. Let’s go through the process below.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=FLOOR(D5, IF(D5>0, 0.001, -0.01))

Here, IF(D5>0, 0.001, -0.01) will return the Significance value for the FLOOR Function which is 0.001. The formula then will be simplified to FLOOR(D5, 0.001) which will return 23.345. We want 3 numbers after the decimal point so we set the Significance value to 0.001. You can also use the following formula instead of this one. It will give you the same result too.

=FLOOR(D5, 0.001)
  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

how to reduce decimals in excel

  • Use the Fill Handle to AutoFill the lower cells.

Thus you can reduce decimals from a number in Excel using the FLOOR and IF Functions.

Read More: How to Insert Dot between Numbers in Excel (3 Ways)


10. Using CEILING Function to Reduce Decimals

Another function that we can use to reduce decimals is the CEILING Function. In this section,  we want to keep 2 numbers after the decimal. Let’s go through the procedure below for a better understanding.

Steps:

  • Make a new column for reduced percentage and type the following formula in cell E5.
=CEILING(D5,0.01)

how to reduce decimals in excel

Here, the CEILING Function returns the approximate value of cell D5 with 2 numbers after the decimal. As we want 2 numbers after the decimal point, we set the Significance value to 0.01.

  • Hit the ENTER button and you will see the reduced decimal format of the profit percentage in D5.

  • Use the Fill Handle to AutoFill the lower cells.

how to reduce decimals in excel

By following this approach, you can reduce decimals from a number in Excel with the help of the CEILING function.

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


Download Practice Workbook

Here I’m giving you the dataset of this article so that you can practice these methods on your own.


Conclusion

Suffice to say, you will learn almost all the easiest possible ways to reduce decimals in Excel after reading this article. If you have any questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.


Related Articles

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo