How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

Solution to the incorrect display of the ID number when entering it in the Excel form:

1. First open excel, (because there are too many ID numbers, so (To be displayed) So now select the cell, right-click and select the "Format Cells" item in the pop-up menu.

2. In the "Format Cells" menu, click "Text" in the "Number" menu item.

#3. Enter the ID number in the cell to display it completely, as shown in the figure.

The above is the detailed content of How to solve the problem that the ID number is not displayed properly when entering it in the Excel form. For more information, please follow other related articles on the PHP Chinese website!