Jupiterimages/Goodshoot/Getty Images

Reduce Decimal Places

Step 1

Highlight the cells you want to modify.

Step 2

Select the Home tab.

Step 3

In the Number group, click the right‑arrow button to decrease decimal places. This changes only the display; to alter the underlying value, use the ROUND function.

ROUND Function

Step 1

Select an empty cell where you want the rounded result.

Step 2

Enter the formula =ROUND(A1,x), where A1 is the reference to your original number.

Step 3

Replace x with the number of significant digits you wish to keep. For example, to round 1.377 to 1.38, use x = 2. To drop digits to the left of the decimal, use a negative number: rounding 145,345 to 145,000 requires x = -3.

Note

These instructions are based on Excel 2010 and 2013. Some steps may differ in other versions.