The reason is that when the numbers in Excel reach 12 and 12, they will be automatically converted into scientific counting method, and those instructions that do not become scientific counting method are not enough 12 digits. If you want to display all the numbers in Excel, you can use the column-text method to add text tags to the number cells. The specific adding method is as follows:

Required materials: Excel.

First, select the columns to display as text.

2. Enter the "Data" option and click "Detach".

Third, the first step is to click "Next" directly.

Fourth, the second step is still to click "Next" directly.

Verb (short for verb) Check the "text" in step 3 and click "Finish".

6. As shown below, after using the column-text method, a small green triangle text mark will be added to the upper left corner of the selected cell, and the scientific counting method will be displayed as text.