HomeApplicationOffice information

Instructions for rounding decimal numbers after commas in Excel

The round function in excel helps you round down decimal numbers into natural numbers without commas. So, how do you want to round decimal places after commas? The following article details how to round decimal places after comma in excel.

For example, the following data table wants to round decimal places after a 2-digit comma.

Instructions for rounding decimal numbers after commas in Excel Picture 1

Step 1: Select the entire column of data to be rounded -> right click and select Format Cells .

Instructions for rounding decimal numbers after commas in Excel Picture 2

Step 2: The dialog box appears in the Number tab select Number -> in the Decimal places section select the number of digits to round after the comma, for example here choose 2 .

Instructions for rounding decimal numbers after commas in Excel Picture 3

Click OK to get the result, all values ​​in the unit price column are rounded to 2 digits after the comma.

Instructions for rounding decimal numbers after commas in Excel Picture 4

In case you want to have high accuracy, you can round 4 digits after a comma. In Decimal places, click 4 :

Instructions for rounding decimal numbers after commas in Excel Picture 5

Results get the decimal places that contain the 4 digits after the comma:

Instructions for rounding decimal numbers after commas in Excel Picture 6

Or you can also absolute rounding only after a 1-digit comma, the values ​​are then rounded:

Instructions for rounding decimal numbers after commas in Excel Picture 7

Above is how to round decimal after comma, hope to help you.

Good luck!

3.9 ★ | 9 Vote

You should read it

May be interested

  • Convert commas to dots in ExcelConvert commas to dots in Excel
    by default, the number format in excel follows international standards separating thousands with commas and decimals as dots. this way of writing is in contrast to the vietnamese writing style, so this article i will guide how to change commas
  • How to separate thousands by commas in ExcelHow to separate thousands by commas in Excel
    the decimal number on excel will help us separate thousands, hundreds, ... units when entering the calculation number or with the currency in the data table.
  • TIME function - Function returns decimal numbers for a specific time value in ExcelTIME function - Function returns decimal numbers for a specific time value in Excel
    time function: the function returns the decimal number for a time value. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: time (hour, minute, second)
  • Instructions to stamp negative numbers in ExcelInstructions to stamp negative numbers in Excel
    during the spreadsheet process on excel, we will have to work with many types of numbers, including negative numbers. and if you want to differentiate negative numbers from other numbers in the data sheet, you can format close or red brackets to distinguish them.
  • How to round up sums in ExcelHow to round up sums in Excel
    how to round up sums in excel. in fact, very often accounting work requires rounding the money. when you use an automatic calculation formula, it doesn't always produce whole numbers. however, according to monetary rules: for example, dong, the amount will be whole numbers without fractional parts.
  • 3 ways to convert time to decimal numbers in Excel and how to convert it back3 ways to convert time to decimal numbers in Excel and how to convert it back
    in this article, we will show you 3 ways to convert time to decimal numbers in excel and how to convert it back. please follow the following article to know how to do it in detail
  • Round a number in ExcelRound a number in Excel
    the following article shows you how to round decimal places after commas in excel.
  • How to change the dot to a comma in Win 10How to change the dot to a comma in Win 10
    how to change the dot to a comma in win 10. according to european regulations, large numbers will use commas to prevent the division of rows of units such as 1,000; 2,000 or 15,000. and the dot will be used to separate decimal points like 0.1 or 0.025…
  • How to convert commas to dots in Excel - Convert unit separatorHow to convert commas to dots in Excel - Convert unit separator
    in excel, to separate units in data, we can use periods or commas. so how to convert a period to a comma or vice versa?
  • How to Replace Comma with Period in ExcelHow to Replace Comma with Period in Excel
    this is an article on how to replace commas with periods in excel. manually replacing commas with periods in excel can be very time consuming.

Office information