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".
Solution:
You can see that the last four digits of the entered ID number are not "0000" , but "0356".
But when we move the mouse and confirm the input information, it will 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.
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.
Don’t worry, we can click on the small symbol in the upper left corner of the cell and select “Ignore Errors”.
In this way, the error message symbol in the upper left corner of the cell will disappear.
#At this time, there are still English single quotes " ' " in front of the ID number in the cell, as shown in the figure.
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!