How do I enter the ID number into 0 in Excel?

Source: Internet
Author: User

In the company, the school, often encounter needs in Excel to enter the ID card scene, but the entry will find the ID card number into a scientific statistics, again click found the last three became "0", this How to solve it?

To enter a 18-digit number.

The last three digits became "0".

The reason is that Excel currently supports up to 15 digits, more than the default number of all defaults to "0", the solution is very simple, the format from "numeric" to "text." Since the identity card number as a fixed number does not require operational requirements, it should be attributed to the orderly text.

First, in the table, enter the English Half-width "" "(the key after the colon), the function is to change the table item's properties to" text. "

Method Two: If you do not first enter which symbol, there is a more general method, in the "toolbar" drop-down format list, click the bottom of the "text" on the line.

Method Three: Right-click in the selected cell, select Format cells, select text in the Number tab, and OK.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.