Home>Article>Topics> What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

烟雨青岚
烟雨青岚 Original
2020-07-08 11:17:32 25082browse

Solution: First open the excel table; then enter the ID number in the cell, and add a single quotation mark " ' " in English input method mode before the ID number; then click on the upper left corner of the cell Click the small triangle symbol in the corner and select "Ignore errors".

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

Solution:

You can see that the last four digits of the entered ID number are not "0000" , but "0356".

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

But when we move the mouse and confirm the input information, it will change to "0000".

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

At this time, we add a single quotation mark " ' " in English input method mode before the ID number, as shown in the figure.

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

We found that although the last four digits of the ID number did not change to "0000", an error message appeared in the upper left corner of the cell.

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

Don’t worry, we can click on the small symbol in the upper left corner of the cell and select “Ignore Errors”.

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

In this way, the error message symbol in the upper left corner of the cell will disappear.

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

#At this time, there are still English single quotes " ' " in front of the ID number in the cell, as shown in the figure.

What should I do if the last four digits of the ID card entered into the Excel table change to 0000?

Recommended tutorial: "excel tutorial"

The above is the detailed content of What should I do if the last four digits of the ID card entered into the Excel table change to 0000?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn