What should I do if the ID card shows E+17 after copying and pasting it into exls?

What should I do if E 17 is displayed after copying and pasting the ID card into exls?

First enter the ID number in the cell. At this time, the ID number is not displayed in the cell. Instead, the ID number is recognized as a number and displayed in scientific notation.

Recommended: "excel tutorial"

Right-click on the cell, and then select "Set Cell" from the right-click menu Format".

In the format cell window that opens, click the "Number" tab, then select "Text" from the category list in the Number tab, and then click " Sure".

At this time, return to the Excel editing interface. The ID number that was just displayed in scientific notation is now displayed as a complete ID number.

The above is the detailed content of What should I do if the ID card shows E+17 after copying and pasting it into exls?. For more information, please follow other related articles on the PHP Chinese website!