What format is used to form the ID number?

The ID card number in the table needs to be in "text" format. The specific setting method: first select the cell, right-click the mouse and select "Set Cell Format"; then select the "Text" format and click the "OK" button. Can.

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

In the data report, the ID number column is all displayed in scientific notation, and it remains the same even if the cell is stretched.

We now want to restore the format of the cell. First, select a cell, right-click and select "Format Cell"

The default format of Excel table cells is the regular format. If the regular format is greater than 11 digits, use scientific notation.

So what you want to choose is the text format (the displayed value is consistent with the input content), and then click the OK button

The displayed content remains unchanged at first glance. Here you need to double-click the cell content, and then you can see the value in the correct input format

# #Because the data table data is relatively large, you can select the data and click the format brush on the toolbar to brush all the following data with the format brush so that the following data can also be presented in the same format

To read more related articles, please visit

PHP Chinese website! !

The above is the detailed content of What format is used to form the ID number?. For more information, please follow other related articles on the PHP Chinese website!