How to enter the ID card number in Excel and answer the question

This article mainly explains in Excel how to enter the ID card number question and the solution, hoped everybody can earnestly read, has learned the knowledge in the article.

Typing a very long number in Excel is a difficult task, although each cell can enter 255 characters, but that is to the letter, for the number, more than 12 digits in Excel directly in the scientific notation to display.

Now that Excel is creating such a problem, how do we avoid it?

Method One: Simply select the cell that needs to enter the ID number, enter a single quote "'" before entering the ID number, and then enter the ID number, which will obediently stay there as a 18-digit figure, without becoming a scientific notation.

Method Two: Before entering, select the column to which you want to enter your ID number, and then enter the format | cell | number, and select text in category. Another option is to select Custom in category, and then select @ on the right "type" option. And according to my experience, must be in the input number before the format set, if the number of the return to the format, the display will be incorrect.

Read the above article on how to enter the excel in the ID card number problem and answer whether there is understanding, I hope in the future work a lot of practice, proficiency in the master.