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.