Home > Topics > excel > body text

Why does the ID number in excel change to 0000?

青灯夜游
Release: 2021-01-20 15:23:51
Original
80275 people have browsed it

Reason: The numerical precision of the Excel table is 15 digits, and it can only display 15 digits. If it exceeds 15, it will automatically become 0, and it is irreversible. Solution: 1. Right-click the cell and select "Format Cells"; 2. In the pop-up "Format Cells", select the "Text" category under the "Number" tab and click "Confirm" ".

Why does the ID number in excel change to 0000?

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Related learning recommendations: excel tutorial

The reason why entering the ID number in excel will change to 0000:

The numerical value of EXCEL The precision is 15 digits. The 0 digits after numbers exceeding 15 digits will automatically become 0 and are irreversible.

Solution: Set the cell format to text format

1. Open the EXCEL table that needs to be operated, and enter the cell where the ID number needs to be entered. Right-click and select "Format Cells."

Why does the ID number in excel change to 0000?

#2. In the pop-up "Format Cells", select the "Text" category under the "Number" tab and click "Confirm".

Why does the ID number in excel change to 0000?

3. Return to the EXCEL table and re-enter the ID number in the cell set to text format. It is found that the input can be successful and the last few digits will not be modified by the system. is 0.

Why does the ID number in excel change to 0000?

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of Why does the ID number in excel change to 0000?. 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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!