Excel Practical Typing Tips

First, text entry skills

Enter a sequence number starting with 0

When the number in the direct input cell is first 0 o'clock, the system will be removed by default

You only need to change the cell format to text or use the single quotation mark (') in the English state before the cell is entered.

For example: ' 0001

>>>>>0001

Enter your ID number

The number of cells with more than 11 digits will be shown by a scientific notation,

Entering a 18-digit ID will display the cell in scientific notation, and if the cell format is selected, the number of digits after the cell is found to become 000

Ditto, use text cell formatting or use single quotation marks in English

Segment Display Phone number

Excel Practical Typing Tips