Fast typing in Excel in the long string of digital skills two

Entering a long string of numbers in Excel can sometimes cause problems, such as entering an ID number or serial number, as long as the serial number is more than 15 digits, and the input results are expressed in scientific notation.

Method First, right click on the cell blank, and then in the pop-up menu, select Format Cells, in the cell formatting window in the Number column category Drop-down list, select text.

Method Two, enter a number in the first half of the single quotation mark, and then enter the number, you can achieve the same effect. It should be noted that single quotes must be entered in English state.