It is very necessary to limit decimal places in Excel to progress with further calculations. Sometimes it is irritating to have so many digits after the decimal place. So, in this article, we will give you some easy ways to limit decimal places.

**Table of Contents**hide

## Why IsÂ Limiting Decimal Necessary?

To make calculations clean and fruitful, we sometimes round our decimal places so that it does not bother our calculations. So instead of using 3.399, we will use 3.40, and we will see how this can be done to decrease decimal places in Excel. Thatâ€™s why we need to know the methods to Limit Decimal Places in Excel. Excel allows highest 127 decimal places. So rounding up is the best options to make calculation easier.

## How to Limit Decimal Places in Excel: 5 Easy Ways

Here we will discuss 5 easy ways to limit decimal values so that you can have everything in your hands easily. In those methods, we will use the **Format Cells **dialog box**, the ROUND function**, the **Number **group from the **Ribbon**, and utilize Excel **Editing options** to accomplish the task to limit decimal places in Excel.

### Method 1: Using Format Cells Command to Limit Decimal Places in Excel

Here we are going to use **Format CellsÂ **command to limit decimal places in Excel. Letâ€™s have a look at the description below.

**Steps:**

- Firstly, we will select the stock price in USD in the
**D**column.

- Then, we will right-click on it and go to the
**Format Cells**from the menu.

- Next, right-click on it, and select the
**Number.** - Then, select
**Decimal Places**as 2. - Finally, press
**OK**.

- Finally, we will find the result given in the image below by limiting the decimal places.

**Read More: **How to Reduce Decimals in Excel

### Method 2: Using ROUND Function to Limit Decimal Places in Excel

**The ROUND function** easily changes the decimal places according to what you want to decrease decimal places in Excel.

**Steps:**

- First, select the
**E5**cell and put down the following formula by assigning a value of the*num_digit*argument of**the ROUND function**as 2.

`=ROUND(D5:D9,2)`

- Here we are selecting
**D5:D9**cells to round all the numbers of stock prices in USD.

- Finally, the function will show the following result.

**Read More: **How to Change Decimal Places in Excel

### Method 3: Using Number Formatting Group for Limiting Decimal Places

Here we will go to the **HOME** tab, then go to **Number, **then easily select** Decimal Places** 2. Thatâ€™s how we are going to limit decimal places

**Steps:**

- At first, we have to select the stock price in USD in the
**D**column.

- Then we will go to the
**Number**group**.**

- Finally, we will select the
**Number**option with**two decimal places by**setting it to 2.

- Then, press
**OK**. - Finally, we will get the result below.

**Read More: **How to Add Decimals in Excel

### Method 4: Using Number Group from Ribbon for Limiting Decimal Places

Here is the easiest method, just go to the **HOME **tab then there is an option to decrease the decimal**.**

- Firstly, we will select the cells in the
**D.**

- Click on the
**Home**tab**.** - Then, click on the marked icon to decrease the decimal places from the
**Number**group.

- Now, we are going to show the result below.

### Method 5: Utilizing Excel Editing Options to Limit Decimal Places in Excel

Here you can permanently change decimal places into 2 and change it after you want.

- Firstly, we will select the data table.

- Firstly, we will go to the
**File**menu.

- Secondly, we will select the
**Options**from the menu.

- Then, we will select
**Advanced**from the left thumbnail. - Afterward, select the
**Automatically insert a decimal**point option. - Finally, customize the
**Places**option with 2.

- Finally, then we will get the final result.

**Download Practice Workbook**

You may download the following workbook to practice yourself.

## Conclusion

Above those methods, we can easily limit decimal places in Excel. You can limit decimal places without breaking any sweat if you follow them properly. If you have any questions or feedback regarding this article, please leave them in the comment box.

## Related Articles

- How to Remove Decimals in Excel
- How to Convert Decimal to Whole Numbers in Excel
- How to Convert Decimal to Fraction in Excel
- How to Reduce Decimal Places Permanently in Excel
- How to Change Decimal Separator in Excel
- How to Remove Decimals in Excel Formula Bar
- How to Change 1000 Separator to 100 Separator in Excel
- Excel Decimal Places Problem