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

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

青灯夜游
Release: 2023-03-10 11:14:20
Original
47818 people have browsed it

Reason: The ID number is a numeric string. If you input it directly, Excel will think it is a numerical data; when the number of data exceeds 11 digits, Excel in the regular format will convert it Recorded in scientific notation, when the number exceeds 15 digits, Excel will only correct it to 15 digits, and the values ​​in the subsequent digits will all be 0. Solution: 1. Click the cell where the ID number is located; 2. Right-click the cell and select "Format Cells"; 3. Click the "Number" tab, select "Text" from the category list, and click "Sure".

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

The operating environment of this tutorial: windows10 system, WPS office13.0.503.101 version, Lenovo v340 computer.

Why does entering the ID number in the Excel form change to another form?

This is because the ID number is a numeric string. If you input it directly, Excel will think it is a numerical data. When the number of data exceeds 11 digits, Excel in regular format will record it as scientific notation

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

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

After the number of digits exceeds 15, Excel will only refine it to 15 digits, and the values ​​in the subsequent digits will all be 0.

Solution

If the ID number entered in the excel table changes, you need to adjust the cell format of the table.

1. Click on the cell

Click on the cell where the ID card is located in the table.

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

#2. Click to set the cell format

Right-click on the cell, and then select "Settings" from the right-click menu Cell Format".

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

3. Select the text option

In the format cell window that opens, click the "Number" tab, and then In the Number tab, select "Text" from the category list and click "OK."

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

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

will display the complete ID number in the form.

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

Expand knowledge: It can also be processed when entering the ID number

1. This method is relatively simple. Before entering the ID number, enter a single quote in English format into the cell.

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

#2. Next, enter the ID number after the single quotes.

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

#3. After the input is completed, you will find that the ID number is directly displayed in the cell, and the scientific notation will not be displayed.

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

Related learning recommendations: excel tutorial

The above is the detailed content of Why does the ID number change when I enter it in Excel?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Latest Issues
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template