Excel enter a number or ID number

Source: Internet
Author: User

We usually enter a number in Excel, but you have not encountered this situation, in Excel, enter a string of long string numbers, such as you enter 8888888888888.8 in the Excel cell, the result becomes 8.88889E+13, enter the ID number will also occur in this case ( Have X's ID number except) and this is going on, and the short number does not matter, originally, in Excel when the number of more than 11 digits will be automatically applied to the Count method to display, how to solve the problem of Excel input number, in fact very simple, the cell format text can be, the method is as follows:

Method one, Set cell format method

This approach is appropriate for multiple cells or whole rows of columns, as follows:

Step one, select the cell or whole row of columns that you want to enter a number, click the right mouse button, and select Format cells, as shown in the following illustration:

In step two, select the text option in the Category list box in the number selection card in the Format Cells window, and then click OK, as shown in the figure:

Computer Tutorials

Step three, and then in the formatted cell to enter the number you want to enter, then there will be no scientific counting of the numbers.

Method Two, enter the English half angle single quotation mark

If you want to enter a long string of numbers only rarely, or occasionally input one or two, then you can use this method, that is, in front of the number of a single quotation mark, but note that here must be the English quotation mark is a half-width state, the same can achieve this effect.

Another: The above method can solve the problem of Excel input numbers, and can be applied to excel in the ID card, because the ID card number is also more than 11, so you have to enter the ID number of the cell into text format in order to correctly enter.

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.