3 ways to quickly and efficiently enter ID number in Excel table in win7 system

Office staff often use the excel form to organize the recorded data. When the win7 system enters the employee ID card information in the excel form, whenever the ID number is entered in the form, it is found that the ID number just entered has become a scientific count. Legal format, how can I enter the ID number quickly and efficiently? In response to this problem, the following small series tells you the specific setting method. The specific method is as follows:

Solution 1:

1. In the form that needs to enter the ID number, right click and select “Set Cell Format";
< Br>

2, in the pop-up "cell format" dialog box select "number", then select "text", click OK;

3, then You can enter the ID number in the cell;

Workaround 2:

1, select the form to enter the ID number, and then select “Start” ——“number”arrow in the lower right corner of the tab;

2, in the pop-up "Set Cell Format" dialog box select “Number”—— “Customize”, then select “@” in the “Type” option box (you can also type @ manually), and finally determine;

3, then you can Enter the ID number in the grid.

Workaround 3:

1, switch the input method to the English input method;

2, in the form that needs to enter the ID number Enter “‘” (a single quote) and enter your ID number.

After the above settings, the win7 system can quickly and efficiently enter the ID number in the Excel form, and the user can set it in a way that he is used to.