Why do the last few digits of the ID number in the table always show 0?

The last few digits of the ID number in the table are always displayed as 0 because the Excel table can only display 15 digits, and the last four digits become 0 by default. The solution is to enter the ID number when entering the number. , add a single quotation mark "'" in English in front of the number to fully display the ID number.

Recommended: "Excel Tutorial"

This is because by default in Excel, when inputting into a cell When the number of digits entered 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 the number in "scientific notation" format. All subsequent numbers are displayed as "0". Therefore, if you enter the ID number (18 digits) in digital format, the ID number will not be displayed correctly. The following are common solutions:

① Select the cell (area) where the ID number needs to be entered, open the "Cell Format" dialog box, enter the "Number" tab, and select "Text" under "Category" option, confirm to exit, and then enter the ID number.

②When entering the ID number, add a single quotation mark "'" in English in front of the number to fully display the ID number (don't worry, after confirmation, the single quotation mark is will not be displayed). This method actually also inputs the ID number in text format.

③ Use a custom format to automatically add the first 6 digits of the fixed digital ID number, which is the code name of the province, city, district (county) (such as "340505", etc.). If the holder is the same For districts (counties), if you enter such an ID number, the "Number" label can help you reduce the input workload: select the cell (area) where you need to enter the ID number, and open the "Cell Format" dialog box. Enter the "Number" tab, select the "Custom" option under "Category", then enter: "340505"@ in the box under "Type" on the right, and confirm to exit. In the future, after entering 7 digits and subsequent digits of the ID number (such as "198903040611"), the system will automatically add the corresponding code in front to form a complete ID number (such as "340505198903040611").

The above is the detailed content of Why do the last few digits of the ID number in the table always show 0?. For more information, please follow other related articles on the PHP Chinese website!