What should I do if the ID number in the Excel form is followed by 000?

Cause: The system automatically processes the ID card number as a mathematical number. The ID card number has many digits, and the last few digits are modified by the system to 0. Solution: 1. Open the table, right-click the cell that needs to be processed, and then select "Format Cells"; 2. In the "Number" tab, find and click "Text", and then click "OK" That’s it.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The ID number in the Excel form is followed by 000 because the system automatically processes the ID number as a mathematical number. The ID number has more digits and the last few digits are modified by the system to 0; the solution is to change the cell Just set the format to text format.

The specific operation steps are as follows:

1. Open the EXCEL table that needs to be operated, right-click the mouse in the cell where the ID number needs to be entered, and then click Select "Format Cells".

2. In the "Number" tab, find and click "Text", and then click the OK button below to complete the setting.

3. Return to the EXCEL table and re-enter the ID number in the cell set to text format. It is found that the input can be successful and the last few digits will not be modified by the system. is 0.

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of What should I do if the ID number in the Excel form is followed by 000?. For more information, please follow other related articles on the PHP Chinese website!