Normal input ID number in Excel table

In a lot of times when we are in Excel tabulation, we will find that some of the data entered into the cell when the change, such as: Excel input 01, in the cell will only show a "1", the front of the "0" inexplicably disappeared, The word alliance has made a solution in the front, so we can go ahead and look at it. Today, we will explain in detail the correct use of Excel to enter the ID number.

When you enter the full ID number in Excel, you will find that in the cell, as shown in the form of "4.21221E+17" (see below), what is this? Is it not allowed to enter an ID number in Excel? Actually, in Excel forms, Enter the number more than 12 digits, Excel will automatically convert to scientific notation format, if the input exceeds 15 digits, Excel will automatically convert 15 digits later to "0", so Excel to enter the ID card number is a little skill!

The method for entering your ID number in Excel is as follows:

Method one, before entering the ID number, switch the input method to the "English state", and then enter a single quote "'" in the cell, then enter the ID number, Excel can display the ID card number completely.

Method Two, left mouse click to select the need to enter the identification number of cells, and then click on the menu bar in the format of the "cell" in the pop-up "cell format" in the "number" in the "category" below select "Text" and then determine.

How about that? Now look at your ID number is not already displayed all! In fact, these two methods are also quite simple, according to the truth should belong to Excel form some basic knowledge!