Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Change Decimal Places in Excel (3 Effective Ways)

If you don’t need irrelevant decimal places in cells as they produce ##### symbols to show, or you don’t want to precision down to the microscopic level, then you can change decimal places in Excel to get the number you wish. In this article, you will learn 3 effective ways to change decimal places in Excel.


Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article.


3 Effective Ways to Change Decimal Places in Excel

1. Using Increase Decimal and Decrease Decimal Buttons

The most common way to change decimal places is to use increase and decrease decimal buttons. Here is the decimal number. Our goal is to change decimal places.

Using Increase Decimal and Decrease Decimal Buttons

Just follow the steps below to do this.

Steps:

  • First, select the cell that contains the number. Then go to the Home tab >> click on the Number group >> click on Increase Decimal Button until you get your desired decimal number.

Using Increase Decimal and Decrease Decimal Buttons to Change Decimal Places in Excel

Here is the new decimal number. If we increase the decimal places to more than the number initially has, Excel just includes zeros to make up.

Again, let’s decrease the decimal places in our number. In order to do this, just repeat the steps above. Then, use the Decrease Decimal button as shown in the following image.

Using Increase Decimal and Decrease Decimal Buttons to Change Decimal Places in Excel

Here is the result of decreasing the decimal places in our number. You need to keep in mind that in case of decreasing decimal places, Excel round the figures.

Read More: How to Add Decimals in Excel (3 Easy Ways)


2. Change Decimal Places in Excel Using Cell Formatting

The second most common way to change decimal places is to use Cell Formatting. It is done by applying a built-in number format. You need to follow the steps below to apply this method.

Steps:

  • First, select the number. Then, click on the Home tab >> click on the Number group >> click on the Arrow sign at the down-right corner of the number box.

Change Decimal Places in Excel Using Cell Formatting

  • A Format Cells dialog box will appear. Under the Number section, select Number, and into the Decimal Places box, put your desired count number at which decimal places you want to round your number. In this example, we take 3 as we want to display our number to 3 digits after the decimal point. Finally, click on OK.

Change Decimal Places in Excel Using Cell Formatting

Here is the result.

Change Decimal Places in Excel Using Cell Formatting

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


Similar Readings


3. Using Excel Functions

Excel provides several functions and formulas to change decimal places. In this tutorial, you will learn to apply the 3 most effective functions to change decimals.

3.1 Using ROUND Function

The ROUND function rounds a number to a specified number of digits.

The 1st argument is the number you need to round. You can use cell reference instead of putting the number.

And, the 2nd argument is the number of digits you need to round the number to.

To apply the ROUND function, just follow the steps below.

Steps:

  • Go to cell C4, and type the following formula. Press Enter.
=ROUND(B4,3)

Using a Function in a Formula to Change Decimal Places in Excel

Here is the result of the rounded number at 3 decimal places.


3.2 Using ROUNDUP Function

The ROUNDUP function rounds a number up, away from zero.

To apply the ROUNDUP function, just write down the following formula in cell C4. Press Enter.

=ROUNDUP(B4,2)

Using ROUNDUP Function

Here is the result of the rounded number at 2 decimal places.


3.3 Using ROUNDDOWN Function

Conversely, The ROUNDDOWN function rounds a number down, toward zero.

Again, to apply the ROUNDDOWN function, copy the following formula and paste it into cell C4. Then, press Enter.

=ROUNDDOWN(B4,3)

Using the ROUNDDOWN Function

Here is the number that is rounded down at 3 decimal places.

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


Conclusion

In this tutorial, I have discussed 3 effective ways to change decimal places in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Hafiz Islam

Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo