Joke Collection Website - Public benefit messages - How to Enter Logistics Order Number in excel Form

How to Enter Logistics Order Number in excel Form

1, open EXCEL, create a new document, and directly enter the logistics order number in the cell, but the express order number is displayed incorrectly, and the complete order number cannot be displayed. Next, set the cell.

2. Select the cell where the courier number has been entered, click the right mouse button and select Format Cell.

3. In the pop-up dialog box, select a number, click the value, and jump the decimal place to 0.

4. After the setting is completed, all numbers will be displayed. This problem will appear when inputting long numbers in excel, such as the commonly used ID number, and this method can be solved.