How to Limit Decimal Places in Excel (5 Methods)

Why Is Limiting Decimal Necessary?

To ensure clean and efficient calculations, we often round our decimal values. For instance, instead of using 3.399, we might prefer to display it as 3.40. Let’s delve into the methods for limiting decimal places in Excel.


Method 1 – Using Format Cells Command:

Steps:

  • Select the stock price in USD from column D.

Selecting data to limit decimal places

  • Right-click on the selection and choose Format Cells from the menu.

Selecting Format Cells

  • In the Number tab, select Decimal Places and set it to 2.
  • Click OK to apply the formatting.

Selecting decimal places to limit decimal places in excel

  • The result is shown below:

Selecting Dataset to limit decimal places

Read More: How to Reduce Decimals in Excel


Method 2 – Using the ROUND Function:

Steps:

  • Suppose you want to round the stock prices in USD (located in cells D5:D9).
  • Enter the following formula in cell E5:
=ROUND(D5:D9,2)

Using Round function for excel limiting decimal places

  • This will round all the numbers to two decimal places.

Showing result of excel limiting decimal places

Read More: How to Change Decimal Places in Excel


Method 3 – Utilizing the Number Formatting Group:

Steps:

  • Go to the HOME tab.

 Sample data set

  • In the Number group, select the option for two decimal places.

Selecting Number group to limit decimal places in excel

Selecting Number decimal places to limit decimal places in excel

  • Press OK.
  • Apply this formatting to the stock price in USD (Column D).

Showing result of excel limiting decimal places

Read More: How to Add Decimals in Excel


Method 4 – Using the Number Group from Ribbon:

Steps:

  • Select the cells containing stock prices in column D.

Sample data set

  • Click on the Home tab.
  • Decrease the decimal places using the icon in the Number group.

Selecting Decimal decrease to limit decimal places in excel

  • The result is shown below.

Showing the result of excel limiting decimal places


Method 5 – Customizing Excel Editing Options:

Steps:

  • Select the data table.

Utilizing Excel Editing options to limit decimal places in excel

  • Go to the File menu.

Selecting Excel file tab to limit decimal places in excel

  • Choose Options.

Selecting options to limit decimal places in excel

  • In the Advanced section, enable the Automatically insert a decimal point option.
  • Customize the decimal places by setting it to 2.

Utilizing Automitically insert to decimal point

  • Here is the final result:

Showing result of excel limiting decimal places


Download Practice Workbook

You can download the practice workbook from here:


 

Related Articles


<< Go Back to Decimals in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Joyanta Mitra
Joyanta Mitra

Joyanta Mitra, a BSc graduate in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology, has dedicated over a year to the ExcelDemy project. Specializing in programming, he has authored and modified 60 articles, predominantly focusing on Power Query and VBA (Visual Basic for Applications). His expertise in VBA programming is evident through the substantial body of work he has contributed, showcasing a deep understanding of Excel automation, and enhancing the ExcelDemy project's resources with valuable... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo