When we use EXCEL forms, we often enter ID numbers or other long numbers, but after entering the ID number, I don’t know why the numbers become like the picture below. Garbled characters. Let's call it E.
Why does it turn into such a garbled E after entering a number? That’s because the number we entered is too large, and EXCEL automatically changes the number to scientific notation. .
Solution:
Change the column belonging to the ID number to "text format".
The specific operation is to select the column, then right-click and select "Format Cells".
In the pop-up dialog box, select "Text" as shown below, and then click "OK".
The above is the detailed content of Why does the electronic form display garbled characters when entering the ID card number?. For more information, please follow other related articles on the PHP Chinese website!
