How to Limit Decimal Places in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Overview image to limit decimal places in excel


Download Practice Workbook

You may download the following workbook to practice yourself.


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.


5 Easy Ways to Limit Decimal Places in Excel

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.

Selecting data to limit decimal places

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

Selecting Format Cells

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

Selecting decimal places to limit decimal places in excel

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

Selecting Dataset to limit decimal places

Read More: How to Calculate Upper and Lower Limits in Excel (2 Methods)


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)

Using Round function for excel limiting decimal places

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

Showing result of excel limiting decimal places

Read More: How to Increase Character Limit in Excel Cell (2 Easy Methods)


Similar Readings


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.

 Sample data set

  • Then we will go to the Number group.

Selecting Number group to limit decimal places in excel

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

Selecting Number decimal places to limit decimal places in excel

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

Showing result of excel limiting decimal places

Read More: How to Set Limit in Excel Cell (5 Simple Ways)


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.

Sample data set

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

Selecting Decimal decrease to limit decimal places in excel

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

Showing the result of excel limiting decimal places

Read More: How to Set Limit for Visible Area in Excel (3 Ways)


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.

Utilizing Excel Editing options to limit decimal places in excel

  • Firstly, we will go to the File menu.

Selecting Excel file tab to limit decimal places in excel

  • Secondly, we will select the Options from the menu.

Selecting options to limit decimal places in excel

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

Utilizing Automitically insert to decimal point

  • Finally, then we will get the final result.

Showing result of excel limiting decimal places


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. For more inquiry, please visit our site ExcelDemy.com.


Related Articles

Joyanta Mitra

Joyanta Mitra

I am Joyanta Mitra. I graduated from BUET EEE in 2021. My college is Notre Dame College. My hobby is to play high graphics computer games. And I am going to pursue my career in your company Softeko. I am working and doing research on Microsoft Excel and here I will be posting articles related to this.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo