Solution: 1. Enter the single quotation mark "'" in English first, and then enter the ID number after the single quotation mark. 2. First right-click on the selected cell area and select "Format Cells"; then in the pop-up window, select "Text" in the "Category" list and click the OK button; finally enter the ID number directly. And press Enter to confirm.
#In Excel, it is often necessary to enter numerical information such as numbers, phone numbers, and ID numbers. But in actual operation, when I input the ID number and press Enter to confirm, the ID number changed into the form of scientific notation, and the last four digits of the ID number all changed into the format of "0000", and the display This is not right.
#So how to solve it, this article will introduce it below.
Method 1:Add single quotes method.
This method means to enter the single quotation mark "'" before entering the ID number.
First select the cell where you want to enter the ID number.
Close the Chinese input method and enter the single quotation mark "'" in the cell.
Enter the ID number after the single quotation marks.
#After inputting and pressing Enter to confirm, the ID number will be saved in the cell in text format, and the number will not change. This preserves the accuracy of the ID number.
#Method 2: Set cell format method.
This method is to set the format of the cell before entering the ID number. First select the cell range to be set.
Right-click on the selected cell area and select the "Format Cells" command in the pop-up right-click menu.
In the pop-up "Format Cells" dialog box, select "Text" in the "Category" list and click the OK button.
Directly enter the ID number and press Enter to confirm.
#The ID number will be saved in the cell in text format, and the number will not change.
Related learning recommendations:excel basic tutorial
The above is the detailed content of What should I do if the last four digits of the ID number in Excel change to 0000?. For more information, please follow other related articles on the PHP Chinese website!
