Current location - Quotes Website - Personality signature - In excel, 18 ID card has a comma in the upper left corner. How to get rid of it and make the ID number normal?
In excel, 18 ID card has a comma in the upper left corner. How to get rid of it and make the ID number normal?
The method of removing the comma of 18 ID card is as follows (taking excel20 19 of windows 10 system as an example):

1, open the document, and you can see that there is a comma in the upper left corner of the ID card.

2. Right-click the cell and click Format Cell in the pop-up drop-down menu.

3. Click the special button in the dialog box that opens automatically.

4. Then click the OK button in the lower right corner.

5. Then you can see that the comma disappears.