Open the file with Excel, fix the problem that the length of the long number after several become 0

Have not known this method before, know the skip it, do not spray.

We save the ID number, the order number, the phone number, the bank card number, etc. into the text, but when you open it using Excel

Usually become the style of science and technology law

If we are actively saving data to Excel, you can format cells as text

But sometimes this data is not entered from Excel, for example, we export from the website.
For example, the store export order information, the order number is often very long, and many web site background export data is stored in
The CSV file, and this file is opened by default using Excel. Of course we want to open with Excel, after all, based on
Powerful features of Excel.

For example, after opening:

You can see that the order is in the form of a science and technology law, even though there are more detailed data, but the last two bits are 0.
(but actually the last two digits of the order here are not 0)
Let's use notepad++ or Notepad to open it up and see

This shows that the display is appropriate.
Workaround:
Create a new, blank Excel
Click Data--Select your CSV file from the text

Direct Next

Select Comma, Next
The comma was chosen because we used Notepad to open the CSV file and found that the data for each column was separated by commas.

Format selection text, click Done.

Direct OK (= $A to start from A1)
Final effect

Finish the call:)

Open the file with Excel, fix the problem that the length of the long number after several become 0