Long numbers are displayed incorrectly in Excel

Article translations Article translations
Article ID: 2643223 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

After you enter a long number (such as a credit card number) in an Excel cell, the number is not displayed correctly in Excel. For example,

Collapse this imageExpand this image
2643233


Note Default number format in Excel is General therefore you can display up to 11 digits in a cell.

Workaround

To work around this issue, use one of the following methods.

Method 1: Format the cell as text

To do this, follow these steps:
  1. Right-click target cell, and then click Format Cells.

    Collapse this imageExpand this image
    2696395


  2. On the Number tab, select Text, and then click OK.

    Collapse this imageExpand this image
    2696396


  3. Then type a long number. (Be sure to set the cell format before you type the number)

    Collapse this imageExpand this image
    2643236


  4. If you do not want to see the warning arrows, click the small arrow, and then click Ignore Error.

    Collapse this imageExpand this image
    2696397


    Collapse this imageExpand this image
    2643238


Method 2: Use a single quotation mark

When you enter a long number, type a single quotation mark (') first in the cell, and then type the long number.

For example, type '1234567890123456789 and the quotation mark will not be displayed after you press ENTER.

Collapse this imageExpand this image
2696398


Your opinion is important to us! Do not hesitate to tell us what you think of this article using the comment field located at the bottom of the document. This will allow us to improve the content. Thank you in advance! 

Properties

Article ID: 2643223 - Last Review: May 26, 2014 - Revision: 11.2
Applies to
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
Keywords: 
kbstepbystep KB2643223

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com