Note Default number format in Excel is General therefore you can display up to 11 digits in a cell.
Method 1: Format the cell as textTo 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 markWhen 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.
Article ID: 2643223 - Last Review: May 26, 2014 - Revision: 1