Reason: The ID number is a numeric string. If you input it directly, Excel will think it is a numerical data; when the number of data exceeds 11 digits, Excel in the regular format will convert it Recorded in scientific notation, when the number exceeds 15 digits, Excel will only correct it to 15 digits, and the values in the subsequent digits will all be 0. Solution: 1. Click the cell where the ID number is located; 2. Right-click the cell and select "Format Cells"; 3. Click the "Number" tab, select "Text" from the category list, and click "Sure".
The operating environment of this tutorial: windows10 system, WPS office13.0.503.101 version, Lenovo v340 computer.
Why does entering the ID number in the Excel form change to another form?
This is because the ID number is a numeric string. If you input it directly, Excel will think it is a numerical data. When the number of data exceeds 11 digits, Excel in regular format will record it as scientific notation
After the number of digits exceeds 15, Excel will only refine it to 15 digits, and the values in the subsequent digits will all be 0.
Solution
If the ID number entered in the excel table changes, you need to adjust the cell format of the table.
1. Click on the cell
Click on the cell where the ID card is located in the table.
#2. Click to set the cell format
Right-click on the cell, and then select "Settings" from the right-click menu Cell Format".
3. Select the text option
In the format cell window that opens, click the "Number" tab, and then In the Number tab, select "Text" from the category list and click "OK."
will display the complete ID number in the form.
Expand knowledge: It can also be processed when entering the ID number
1. This method is relatively simple. Before entering the ID number, enter a single quote in English format into the cell.
#2. Next, enter the ID number after the single quotes.
#3. After the input is completed, you will find that the ID number is directly displayed in the cell, and the scientific notation will not be displayed.
Related learning recommendations: excel tutorial
The above is the detailed content of Why does the ID number change when I enter it in Excel?. For more information, please follow other related articles on the PHP Chinese website!