How to enter the ID card number in excel

Method 1: with some tips on the input method, we use the shift key on the keyboard to switch the input method to the English state.

1. Then, enter "'", which can be entered in English.

2. Now, if we enter the ID card number again, it will not be automatically converted to the scientific calculation method.

Method 2: Right-click a cell and select "set cell format".

1. In the cell where you want to enter the ID card, right-click the cell and choose "set cell format" from the context menu ", in the displayed dialog box, click "text" on the "numbers" tab.

2. Then we enter the ID card number.

The Yunqi community editor reminds you that if you want to batch enter the ID card number, you only need to select this column in the box and then set the cell attribute.