When filling data in excel, what type of storage is used for ID number?

Fill data in excel, and the ID number is stored in the "text" type. In text cell formatting, numbers are treated as text; the cell displays exactly what is entered.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Fill data in excel, and the ID number is stored in the "text" type.

Because the ID card has too many numbers, Excel cannot save it directly.

Let’s try to enter the ID number first.

# After inputting, it will be displayed like this and you will find that the number has changed. This is because the computer uses binary algorithm.

#The default number format in Excel is "General", which can display up to 11 significant digits. If more than 11 digits are exceeded, it will be expressed in scientific notation.

Solution:

We enter a "'" in English before entering the number, and then enter the number

can save the number completely, that’s the effect.

If you need to enter many ID numbers, you can select the entire column and right-click.

In setting cell format, select the text and click OK, so that you can directly enter the ID number in batches.

Related learning recommendations: excel basic tutorial

The above is the detailed content of When filling data in excel, what type of storage is used for ID number?. For more information, please follow other related articles on the PHP Chinese website!