What should I do if the ID number in the form becomes e+17?

Solution: 1. Select the cells that need to be processed, right-click the mouse, and select "Format Cells" from the right-click menu; then in the formatted cell window that opens, click the "Number" tab , select "Text" from the category list and click "OK". 2. Before entering the ID number, enter a single quotation mark in English format in the cell.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Solution to change form ID number to e 17

Method 1:

1. First enter the ID number in the cell. At this time, the ID number is not displayed in the cell. Instead, the ID number is recognized as a number and displayed in scientific notation.

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

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

#4. Now return to the Excel editing interface. The ID number just displayed in scientific notation has been displayed as a complete ID number.

Method 2:

1. This method is relatively simple. Enter it in the cell before entering the ID number. An English-formatted single quote.

#2. Next, enter the ID number after the single quotes.

#3. After the input is completed, you will find that the ID number is directly displayed in the cell, and the scientific notation will not be displayed.

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the ID number in the form becomes e+17?. For more information, please follow other related articles on the PHP Chinese website!