When entering the ID card in excel, something similar to 5.13429e+17 appears?

When entering the ID card in excel, 5.13429e 17 appears.

When entering the ID card in excel, 5.13429e 17 appears. This is because Excel defaults to scientific notation for numbers exceeding 11 digits, and for numbers above 15 digits, the excess is counted as 0. All can be shown by setting the number as text.

The steps are as follows:

1. Open the EXCEL table that needs to be operated, select the relevant cells, right-click the mouse and select "Format Cells".

#2. On the Number tab page, click to select "Text", and then click the OK button.

#3. Return to the main document, re-enter the ID number, press Enter and find that it can be successfully entered and all is displayed completely.

Recommended tutorial: excel tutorial

The above is the detailed content of When entering the ID card in excel, something similar to 5.13429e+17 appears?. For more information, please follow other related articles on the PHP Chinese website!