Home >Topics >excel >How to enter ID number when creating an excel form

How to enter ID number when creating an excel form

藏色散人
藏色散人Original
2020-03-16 10:19:3971390browse

How to enter ID number when creating an excel form

How to enter the ID number when making an excel form?

Set cell format;

1. Create a new excel blank table document;

Recommended: "excel tutorial"

How to enter ID number when creating an excel form

2. Directly enter the 18-digit ID number;

How to enter ID number when creating an excel form

3. After pressing Enter, it was found that the format occurred Changed;

How to enter ID number when creating an excel form

4. Right-click a blank cell and click Set Cell Properties;

How to enter ID number when creating an excel form

5. Classifying Select the text and click OK;

How to enter ID number when creating an excel form

6. Continue to enter the 18-digit ID number. You will find that a small green triangle appears in the upper left corner of the cell, which also displays the entire ID number.

How to enter ID number when creating an excel form

The above is the detailed content of How to enter ID number when creating an 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