Instructions for Rounding Decimal Numbers After Commas in Excel

This guide provides a practical overview of Instructions for Rounding Decimal Numbers After Commas, including its main features, benefits, limitations, and important considerations.

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

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

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 .

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

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

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

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

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

Good luck!