Solve the problem that the ID number is followed by 000 in excel form

The solution to the problem that the ID number is followed by 000 in excel: 1. Select the cell with the ID number, then right-click and select [Cell Format], and select [Text] under [Number]; 2. . Press the ['] button to the left of Enter under the English input method, and then enter the ID number.

The operating environment of this article: Windows7 system, Microsoft Office Excel2010, Dell G3 computer.

First, select the cell with the ID number and select as many cells as there are

Right-click and select [Cell Format]

Select [Text] under [Number] and confirm

Then enter the ID number and it will be displayed in full

Method/Step 2

If you want to input quickly, you can press the button ['] to the left of Enter in the English input method

Then enter the ID number

Recommended: "Word Tutorial"

The above is the detailed content of Solve the problem that the ID number is followed by 000 in excel form. For more information, please follow other related articles on the PHP Chinese website!