Enter your ID number in Excel normal display method

Source: Internet
Author: User

After we use Excel to enter the ID number, bank account and so on a longer number, it will become a plus and letter form (as shown below), why?

This is a general problem with digital input. The default number format in Excel is "normal", which can display up to 11 digits in a valid number, and more than 11 digits are expressed in scientific notation.

To enter multiple digits and fully display them, you can try the following two methods:

First, format the cell as text

Select the target cell, right-click, and select Format cells.

On the Number tab, select the Text option from under categories. Press the OK button to save the settings.

Enter the ID number again. (Be sure to format, and then enter the number)

If you don't want the small arrow in the upper-left corner, you can click the small arrow and choose Ignore error.

First, enter a single quotation mark ' and then enter the number

When entering the ID number, add a single quotation mark in English state before the number, so that the ID card number can be fully displayed (the single quotation mark is not displayed after confirmation).

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.