How to change the format of the ID card number in excel?

#How to change the format of the ID card number in excel?

How to change the incorrect format of the ID number in Excel:

1. First select the cell where the ID number is located, right-click - Set Cell Format;

#2. Select the "Text" option in the option box on the left and click OK;

3 .After clicking OK, the original number changes to the left display, but is still displayed in the form of scientific notation;

4. At this time, we double-click the cell, and The complete 18-digit number will be displayed;

5. Careful students will find that this ID number does not seem to be correct, because the last four digits have become 0 ;At this time we need to manually modify the last four digits;

6. Select the cell, a button with an exclamation mark will appear on the left, click and select "Ignore" Error", then the small arrow in the upper left corner of the cell will disappear, ok, the modification is completed;

7. At this time, some students will ask again, if excel The original table was sent to me by someone else. This kind of problem occurs in it. What should I do? First of all, everyone needs to understand why this situation occurs, because the default number length in Excel is only 12 digits. If the length exceeds 12 digits, the entered number will be processed according to the scientific notation method, and the last four digits will be ignored. And the process is irreversible. So in this case, you can only ask the person who made the watch to provide your ID number again!

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to change the format of the ID card number in excel?. For more information, please follow other related articles on the PHP Chinese website!