How to enter ID number in excel2010

If you want to know more about excel, you can click: Excel Tutorial

## By default, if the number of digits entered in the current cell of Excel exceeds 11 digits (excluding 11 digits), the system will display the entered number in "scientific notation" format; when the number of digits entered exceeds 15 digits (excluding 15 digits), the system will display all numbers after the 15th digit as "0".

In this way, if we need to enter the ID number (15 or 18 digits), the ID number will not be displayed correctly. At this time, we have two ways to solve this problem:

1. Use the number label

to select the cell where the ID number needs to be entered. (area), open the "Format Cells" dialog box, enter the "Number" tab, select the "Text" option under "Category", confirm to exit, and then enter the ID number. (Be sure to set the format before entering the number)

2. When entering the ID number, Add a single quotation mark "'" in English in front of the number to fully display the ID number (the single quotation mark will not be displayed after confirmation).

Extended information

The cell is the intersection of the rows and columns in the table. It is the component that makes up the table. The smallest unit, cells can be split or merged. The input and modification of individual data are performed in cells.

Cell type defines the type of information presented in the cell, how this information is displayed, and how users interact with it. Users can use two different cell types to set cells in the form.

One is a text format that can be simply associated with a cell.

The other is to display controls or graphical information.

Excel has built-in general, currency, number, percentage, and text types. Third-party table controls often have richer cell types. For example, Spread supports 18 cell types (Mask type, button type, check box type, combo box type, graphic type, etc.).

The above is the detailed content of How to enter ID number in excel2010. For more information, please follow other related articles on the PHP Chinese website!