How to restore excel number display e+17?

Method: First open the excel table, click on the cell, right-click; then click "Format Cells"; then click "Text" in "Numbers"; then click "OK".

Method:

First enter the ID number in the cell. At this time, it is not displayed in the cell. ID number, but recognizes the ID number as a number and displays it in scientific notation.

Right-click the cell and select "Format Cells" from the right-click menu.

In the format cell window that opens, click the "Number" tab, then select "Text" from the category list in the Number tab, and then click " Sure".

At this time, return to the Excel editing interface. The ID number that was just displayed in scientific notation is now displayed as a complete ID number.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to restore excel number display e+17?. For more information, please follow other related articles on the PHP Chinese website!