Home >Topics >excel >Why does the ID number change when I enter it in the form?

Why does the ID number change when I enter it in the form?

藏色散人
藏色散人Original
2021-04-25 15:22:5892577browse

When entering the ID number in the form, it will change because the input content becomes a scientific numerical recording method. The solution: first enter the WPS form, select the data that needs to be set; then right-click the mouse, and Click on Format Cells in the options; finally click on the text under the category.

Why does the ID number change when I enter it in the form?

The operating environment of this article: windows7 system, Dell G3 computer, WPS Office2019 version.

We sometimes record some personal identity information, such as ID number, but every time it is entered, it will be recorded in a scientific numerical format. So how do we enter the ID number correctly?

After entering the WPS form, select the data that needs to be set, and then right-click the mouse.

Why does the ID number change when I enter it in the form?

And click Format Cells in the options.

Why does the ID number change when I enter it in the form?

Click on the text below the category.

Why does the ID number change when I enter it in the form?

Click OK in the lower right corner.

Why does the ID number change when I enter it in the form?

#Enter the ID number again and it will not change.

Why does the ID number change when I enter it in the form?

【Recommended learning: Excel tutorial

The above is the detailed content of Why does the ID number change when I enter it in the 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