Home >Topics >excel >What does the ID card showing e+17 mean?

What does the ID card showing e+17 mean?

藏色散人
藏色散人Original
2021-11-23 11:43:58142118browse

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.

What does the ID card showing e+17 mean?

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.

What does the ID card showing e+17 mean?

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

What does the ID card showing e+17 mean?

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

What does the ID card showing e+17 mean?

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.

What does the ID card showing e+17 mean?

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.

What does the ID card showing e+17 mean?

Next, enter the ID number after the single quotes.

What does the ID card showing e+17 mean?

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

What does the ID card showing e+17 mean?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn