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!