"Go" at the end of Excel is 0 recovery data method

Today from the database to check the data, with Plsql exported to CSV data after opening with Excel after the problem, display problems, Excel will encounter a column because the number is too long, the result has become a scientific notation, and this loss is irreversible, Change its format to text in a timely manner to open with Excel can be displayed normally, I am Excel 2003, the workaround is: Create a new blank form, choose Data, Import external data, import data, in the Import External Data dialog box appears, select the CSV file that does not display properly , OK after coming to the Text Import Wizard step one, the original data type select the split symbol, point "next", come to step two, the separator symbol Select tab and comma, point "next" to step three, here is the most important, you can select the data type for each data column that will be imported, Because this is to solve the problem can not be displayed correctly, so, here to choose the column that does not display properly, in the "column data format" for it to specify the format of the import, here Select the "text" type, click Finish, and so on after the data can be displayed normally, the name of the white is not.

In fact, this method was seen before, but today search but did not search, it is irritating,,, so I want to write him down.

from:http://blog.csdn.net/v_love/article/details/7623957

"Go" at the end of Excel is 0 recovery data method