What if Excel enters the ID number into 0?

What if Excel enters the ID number into 0?

Method 1:

Before entering the Excel table box, enter the English state of the ' quotes, and then enter the ID number you need to enter the value or the bank card number, etc., after the return of the good. is not very simple to say.

Method 2: Text mode storage

By using digital preservation, a scientific notation is usually displayed, so the identity card number is stored as text, and the problem does not arise. Locate the table you want to enter---format the cell.

In the format item you entered, select the text store. As shown in the following figure

After you set the cell format as text store, then enter the ID number and other information, you can.

Other methods

In addition, you can also copy it into Excel by typing it elsewhere. After the copy is complete, select unformatted storage, or text store.