Why does the ID number in excel change to 0000?

Reason: The numerical precision of the Excel table is 15 digits, and it can only display 15 digits. If it exceeds 15, it will automatically become 0, and it is irreversible. Solution: 1. Right-click the cell and select "Format Cells"; 2. In the pop-up "Format Cells", select the "Text" category under the "Number" tab and click "Confirm" ".

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

Related learning recommendations: excel tutorial

The reason why entering the ID number in excel will change to 0000:

The numerical value of EXCEL The precision is 15 digits. The 0 digits after numbers exceeding 15 digits will automatically become 0 and are irreversible.

Solution: Set the cell format to text format

1. Open the EXCEL table that needs to be operated, and enter the cell where the ID number needs to be entered. Right-click and select "Format Cells."

#2. In the pop-up "Format Cells", select the "Text" category under the "Number" tab and click "Confirm".

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 Why does the ID number in excel change to 0000?. For more information, please follow other related articles on the PHP Chinese website!