What does the ID card showing e+17 mean?

The ID card display e 17 means that the display format uses scientific notation. The solution: 1. Select "Set Cell Format" from the right-click menu, and select it from the category list in the number tab. "Text"; 2. Before entering the ID number, enter a single quotation mark in English format in the cell.

The operating environment of this article: Windows7 system, Microsoft Office Excel2010, Dell G3 computer.

What does the ID card display e 17 mean?

The first method

First enter the identity in the cell ID number. 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.

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.

The second method

This method is relatively simple. Before entering the ID number, enter an ID number in the cell. Single quotes in English format.

Next, enter the ID number after the single quotes.

#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.

Notes

When the cell format is text, the display will be consistent with the input content.

Recommended study: "Excel Tutorial"

The above is the detailed content of What does the ID card showing e+17 mean?. For more information, please follow other related articles on the PHP Chinese website!