1, open the Excel table you need to convert. Here is a special introduction to the phenomenon of multiple figures, we know that, like the ID card, these multi-digit figures, in the normal form are added to a 'to make it display, or change into a "text" mode of the cell form: here are the text form as well as the addition of 's digital form, for everyone to explain the difference in effect after conversion to CSV format.

2, first look at the form of text saved in the form of conversion:

2.1 Then, you can click on the upper-left corner of the office button, select "Save As" in the "other formats":

2.2 Then select the option "CSV (comma-separated) (*.csv)" in the Save As "Save as type":

2.3 Then there will be a prompt to click OK:

2.4 Then there will be a prompt to click Yes:

2.5 Then there will be a prompt to click "Save as" in the "Save as" box:

2.6 Then there will be a prompt to click "Yes" in the "Save as" box. Click "Yes":

2.5 Then when you exit and open the saved CSV file, you will find that the last three digits of the 18-bit data are 0:

3. However, when you convert the CSV file into a txt file by directly modifying the suffix, you will find that the data is normal again.

4, so you can convert to txt to save, direct CSV upload may be a problem, but you can use the following method, it will show the data completely.

5, see the first step above there, the data is saved in the form of ', and then the back of the Save As method is the same, this way the last saved CSV file is still all the data displayed:

6, and this way and then directly converted to txt text data is also normal, just more than a ' sign is. If the data is not too much trouble, then look directly at the Save As method can be, do not have to look at the above explanation for long data.