Home >Topics >excel >How to restore the ID card number showing e+17

How to restore the ID card number showing e+17

coldplay.xixi
coldplay.xixiOriginal
2020-08-22 14:24:1560963browse

How to restore the ID number display e 17: first right-click and select Format Cell; then click on the text and click OK; finally delete the ID number, re-enter the ID number, and press the Enter key. .

How to restore the ID card number showing e+17

[Related learning recommendations: excel basic tutorial]

ID card number display e 17 restored Method:

1. First turn on the computer, then open an excel document, enter the ID number in the cell, and you can see that the ID number displays e 17.

How to restore the ID card number showing e+17

#2. Then right-click and select Format Cells.

How to restore the ID card number showing e+17

3. Then click on the text and click OK.

How to restore the ID card number showing e+17

#4. Then delete the ID number, re-enter the ID number, and press the Enter key.

How to restore the ID card number showing e+17

#5. The result is as shown in the figure, so that the ID number will be displayed normally.

How to restore the ID card number showing e+17

The above is the detailed content of How to restore the ID card number showing e+17. 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