Issue in exporting data to CSV

I am doing export of开发者_C百科 data from database to Excel. After exporting when opening the csv file, the excel application is autoformating the values in excel.

One my cell contained the value -A1177, but it got converted to zero.

Can any one let me know is there any solution to avoid this or switch off this autoformat in excel.

thanks.

The easiest way to do it, is to simply wrap the value in quotes, e.g. asdasd,"-A1177",11/03/1984 in your CSV file. You can also change the format of the column to `Text'.

Otherwise, check out this excellent Stack Overflow Question and Answer

Change column Data Format when importing the text change it to Text

Insert a ' at the start of any formula in Excel and it will be considered a string.

So if possible, check when generating the CSV file if the first char in a given field can be understood as an Excel formula "opener" (off my mind {=, -, +}) and prepend a '.

You can do it for every field, but its only strictly necessary if the text can be misunderstood as a formula.