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!
You should read it
- How to get numbers after commas in Excel
- ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel
- Do not round numbers in Excel, turn off rounding in Excel
- Ways to round numbers in Excel
- How to Change a Comma to Dot in Excel
- How to convert dots to commas in Excel on Windows 7
- How to convert commas into dots in Excel
- Convert commas to dots in Excel
- How to separate thousands by commas in Excel
- Instructions to stamp negative numbers in Excel
- TIME function - Function returns decimal numbers for a specific time value in Excel
- How to round up sums in Excel
May be interested
Reduce the size of PDF files with Free PDF Compressor
Draw a mind map in Word
How to draw tornado charts in Excel
CHOOSE function combines SUM - Conditional sum in Excel
SUMSQ, SUMXMY2, SUMX2MY2, SUMXPY2 functions - Sum function contains squared values in Excel
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel