How to set up Excel ID number format

How to set up Excel ID number format

The first case

Get the data report, ID number This column is all scientific counting methods show that even elongated cells remain the same

Now we want to restore the format of the cell, first select a cell, and then right-click to select the cell format

The default format for Excel table cells is in the normal format, and the general format is larger than 11 digits and is represented by scientific notation.

So you have to select the text format (the display value is the same as the input content), and then click the OK button

The display content is unchanged, here you have to double-click the cell contents, and then you can see the value of the correct input format

Because the data table data is larger, you can select the data to click on the toolbar format brush, the following all the data in a format brush, so that the following data can be rendered in the same format

　　Second case

Enter your own data, first of all you want to enter a column of cells to format text, ' right cell-selected text ' or ' right cell-select the number (but to the right of the number of decimal places to 2 to 0) ' and then enter the value directly