Stop rounding numbers

In Excel, the number that appears in a cell is separate from the number that is stored in the cell. For example, a number with seven decimal places may display as rounded when the cell format is set to display only two decimal places, or when the column isn't wide enough to display the actual number. When performing a calculation, Excel uses the stored value, not the value that is visible in the cell.

To stop numbers from being displayed as rounded, you can increase the number of decimal places for that number, or you can increase the column width.

Note: By default, Excel displays two decimal places when you apply the number, currency, accounting, percentage, or scientific format to cells or data. You can specify the number of decimal places that you want to use when you apply these formats.

  1. Select the column or columns that you want to change.

  2. On the Format menu, point to Column, and then click AutoFit Selection.

    Tips: 

    • You can double-click a boundary to the right of one of the column headings to have the columns resize automatically.

    • To change the column width to a custom size, drag the boundary to the right of one of the column headings until the column is the size that you want.

      Move pointer between column heading C and D, then double-click

  1. Select the cell or range of cells that contains the numbers for which you want to increase the decimal places.

  2. Do one of the following:

    Excel 2016 for Mac: Click the Home tab, and then click Increase Decimal Increase the number of decimal places once for each decimal place that you want to add.

    Excel for Mac 2011: On the Home tab, under Number, click Increase Decimal  Increase the number of decimal places  once for each decimal place that you want to add.

  1. On the Format menu, click Cells, and then click the Number tab.

  2. In the Category list, click Number, Currency, Accounting, Percentage, or Scientific depending on your cell data.

  3. In the Decimal places box, enter the number of decimal places that you want to display.

See Also

Round a number to the decimal places I want

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×