How to Decrease Digits in Excel

Use consistent formatting when displaying similar numbers.
••• Jupiterimages/Goodshoot/Getty Images

Long numbers in Excel can be easier to read when you reduce the numbers of digits displayed on the worksheet. The simplest fix in many cases is to change the display format to decrease the number of decimal places. However, if you want to change the actual cell values, or you want to reduce the number of significant digits to the left of the decimal place, use Excel's rounding function instead.

Reduce Decimal Places

    Highlight the cells you want to modify.

    Select the "Home" tab.

    Click the right arrow in the Number section of the ribbon to decrease the decimal places. Keep in mind this changes only what you see on the screen; to change the actual values in the cells for use in computations, use the ROUND function instead.

ROUND Function

    Select an empty cell in your worksheet.

    Enter the ROUND formula using the following format (assuming your number is in cell A1): \=ROUND(A1,x)

    Replace "x" with the number of significant digits you want to keep. For example, to round 1.377 to 1.38, replace x with "2". If you want to eliminate significant digits before the decimal place, use a negative number. For example, to round 145,345 to 145,000, replace x with "-3".

    Warnings

    • Information in this article applies to Excel 2013 and 2010. It may vary slightly or significantly with other versions.

Related Articles

Components of Homeostasis
Casio Calculator FX-82MS Instructions
How to Find Zeros of Functions in Excel
How to Solve by Simpson's Rule With Excel
How to Create Matrices on a TI-89
How to Create a Normal Distribution Graph in Excel
How to Graph a Distribution for a T-Test
How to Subtract Matrices on Excel
How to Calculate the Correlation Between Two Variables
How to Calculate the Slope of Regression Line
How to Write Notes on a TI-84 Silver Edition Calculator
Subtracting Minutes From Time in Excel
How to Draw a Normal Distribution in Excel
How to Calculate the Rate of Decay
How to Round to the Underlined Place Value Position
How to Calculate Percentage Decrease on a Calculator
How to Solve Linear Programming in Excel
How to Calculate a Delta Percentage
How to Convert CM to Inches in Excel
How to Express "Divisible By" in Excel