Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×