How to Limit the Number of Decimal Places in Excel

This post will guide you how to limit the number of decimal places in Excel. How do I round a number to the specific decimal places with a formula in Excel. How to Limit Number of decimal places with Format Cell Feature in Excel.

Limit Number of Decimal Places with in Formula

Assuming that you have a list of data in range B1:B5, in which contain number values with 3-4 decimal places. And you want to limit the number of decimal places for all numeric values to 2. How to do it. You can use the ROUND function to create a formula to limit the number of decimal places for each numbers. So you can use the following formula:


Type this formula into the Cell C1, and press Enter key on your keyboard, and then copy this formula from Cell C1 to the range C2:C5 to apply this formula.

limit number of decimal places1

You should see that all numbers have been limited to two decimal places.

Limit Number of Decimal Places with Format Cell

You can also use the Format Cell feature to achieve the same result of limiting the number of decimal places for the selected range that contain numbers. Just do the following steps:

#1 select the range of cells that contain numbers with four decimal places.

limit number of decimal places2

#2 right click on it, and select the Format Cells from the popup menu list. And the Format Cells dialog will open.

limit number of decimal places3

#3 click the Number tab in the Format Cells dialog box, and click the Number option in the Category list box, and then type number 2 in the Decimal places box. Click Ok button.

limit number of decimal places4

#4 you should notice that all numbers in the selected range have been changed to two decimal places.

limit number of decimal places5

Related Functions

  • Excel Round function
    The Excel INT function rounds a number to a specified number of digits. You can use the ROUND function to round to the left or right of the decimal point in Excel.The syntax of the ROUND function is as below:=ROUND (number, num_digits)…



Related Posts

Calculate Years Between Dates In Ms Excel

If you are an avid Ms Excel user, then you might have come across a task in which you needed to calculate the years between the dates; you might take it easy and do this task manually, which is also ...

Working Time Calculation Based on Timesheets

In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...

Sort/Rank Numeric Values with Duplicate Values Exist

Excel built-in RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest ...

Calculate Days Open in Excel

If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...

Calculate Grades With VLookup in Excel

Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...


So empty here ... leave a comment!

Leave a Reply