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

Casio Calculator FX-82MS Instructions
How to Find Zeros of Functions in Excel
Components of Homeostasis
How to Solve by Simpson's Rule With Excel
How to Calculate the Slope of Regression Line
How to Round to the Underlined Place Value Position
How to Graph a Distribution for a T-Test
How to Calculate Percentage Decrease on a Calculator
How to Subtract Matrices on Excel
How to Do an Absolute Value Function on the TI-83 Plus
How to Create Matrices on a TI-89
How to Calculate a Delta Percentage
How to Calculate Pearson's R (Pearson Correlations)...
Subtracting Minutes From Time in Excel
How to Create a Normal Distribution Graph in Excel
How to Write Notes on a TI-84 Silver Edition Calculator
How to Calculate Correlation Coefficient Between Two...
How to Convert Tenths to Hundredths
What Does ##### Mean in Excel?
How to Draw a Normal Distribution in Excel