Long numbers are displayed incorrectly in Excel
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,
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:
Right-click target cell, and then click Format Cells.
On the Number tab, select Text, and then click OK.
Then type a long number. (Be sure to set the cell format before you type the number)
If you do not want to see the warning arrows, click the small arrow, and then click Ignore Error.
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.
Related articles
Format numbers as text in Excel for Mac
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!
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for