In the company, the school, often encounter needs in Excel to enter the ID card scene, but the entry will find the ID card number into a scientific statistics, again click found the last three became "0", this How to solve it?
To enter a 18-digit number.
The last three digits became "0".
The reason is that Excel currently supports up to 15 digits, more than the default number of all defaults to "0", the solution is very simple, the format from "numeric" to "text." Since the identity card number as a fixed number does not require operational requirements, it should be attributed to the orderly text.
First, in the table, enter the English Half-width "" "(the key after the colon), the function is to change the table item's properties to" text. "
Method Two: If you do not first enter which symbol, there is a more general method, in the "toolbar" drop-down format list, click the bottom of the "text" on the line.
Method Three: Right-click in the selected cell, select Format cells, select text in the Number tab, and OK.