Home >Topics >excel >How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

尚
Original
2019-07-24 14:40:4226767browse

How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

Solution to the incorrect display of the ID number when entering it in the Excel form:

1. First open excel, (because there are too many ID numbers, so (To be displayed) So now select the cell, right-click and select the "Format Cells" item in the pop-up menu.

How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

2. In the "Format Cells" menu, click "Text" in the "Number" menu item.

How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

#3. Enter the ID number in the cell to display it completely, as shown in the figure.

How to solve the problem that the ID number is not displayed properly when entering it in the Excel form

The above is the detailed content of How to solve the problem that the ID number is not displayed properly when entering it in the Excel form. 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