Home>Article>Topics> What should I do if the last four digits of the ID number in Excel change to 0000?

What should I do if the last four digits of the ID number in Excel change to 0000?

青灯夜游
青灯夜游 Original
2020-08-26 16:29:20 105196browse

Solution: 1. Enter the single quotation mark "'" in English first, and then enter the ID number after the single quotation mark. 2. First right-click on the selected cell area and select "Format Cells"; then in the pop-up window, select "Text" in the "Category" list and click the OK button; finally enter the ID number directly. And press Enter to confirm.

What should I do if the last four digits of the ID number in Excel change to 0000?

#In Excel, it is often necessary to enter numerical information such as numbers, phone numbers, and ID numbers. But in actual operation, when I input the ID number and press Enter to confirm, the ID number changed into the form of scientific notation, and the last four digits of the ID number all changed into the format of "0000", and the display This is not right.

What should I do if the last four digits of the ID number in Excel change to 0000?

#So how to solve it, this article will introduce it below.

Method 1:Add single quotes method.

This method means to enter the single quotation mark "'" before entering the ID number.

First select the cell where you want to enter the ID number.

What should I do if the last four digits of the ID number in Excel change to 0000?

Close the Chinese input method and enter the single quotation mark "'" in the cell.

What should I do if the last four digits of the ID number in Excel change to 0000?

Enter the ID number after the single quotation marks.

What should I do if the last four digits of the ID number in Excel change to 0000?

#After inputting and pressing Enter to confirm, the ID number will be saved in the cell in text format, and the number will not change. This preserves the accuracy of the ID number.

What should I do if the last four digits of the ID number in Excel change to 0000?

#Method 2: Set cell format method.

This method is to set the format of the cell before entering the ID number. First select the cell range to be set.

What should I do if the last four digits of the ID number in Excel change to 0000?

Right-click on the selected cell area and select the "Format Cells" command in the pop-up right-click menu.

What should I do if the last four digits of the ID number in Excel change to 0000?

In the pop-up "Format Cells" dialog box, select "Text" in the "Category" list and click the OK button.

What should I do if the last four digits of the ID number in Excel change to 0000?

Directly enter the ID number and press Enter to confirm.

What should I do if the last four digits of the ID number in Excel change to 0000?

#The ID number will be saved in the cell in text format, and the number will not change.

What should I do if the last four digits of the ID number in Excel change to 0000?

Related learning recommendations:excel basic tutorial

The above is the detailed content of What should I do if the last four digits of the ID number in Excel change to 0000?. 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