Excel Entry ID number or phone number will not display correctly (E+17)

After using Excel to enter the ID number, the bank account and so on the longer number, why becomes has the plus sign and the letter form? The following figure

This is a general problem with digital input. The default number format in Excel is " normal ", which can display up to 11 digits in a valid number, and more than 11 digits are expressed in scientific notation.

To enter multiple digits and fully display them, you can try the following two methods:

• 
  

  Format cells as text

  Select the target cell, right-click, and select format Cells .
  
  
  
  
  

  
  
  
  
  On the Number tab, select the text option from under categories . Press the OK button to save the settings.
  
  
  
  
  

  
  
  
  
  Enter the ID number again. ( be sure to format, and then enter the number )
  
  
  
  
  

  
  
  
  
  If you don't want the small arrow in the upper-left corner, you can click the small arrow and choose Ignore Error .
  
  
  
  
  

  
  
  
  
  
  
  
  

  
  
• 
  

  Enter an English single quote ' before entering a number

  when entering the ID number, add a single quotation mark in English state before the number , so that the ID card number can be fully displayed (the single quotation mark is not displayed after confirmation).