Problem when exporting to CSV
I have a few problems related to formating when exporting data to CSV. I'm following this method: i have a string buffer, to which i add different elements from a list separated by comma. finally i convert this stringbuffer to string and write it to a csv file.
Most of the data are coming properly except some fields like dates or some long valued fields.
My problems are:
1. If the date retrieved from the list is in format 'yyyy/mm/dd', when we view the csv in MSExcel the date format is changed to its default format automatically.
2. The long number retrived from the list is showing as an exponential number in excel.
How can i avoid these two formating issue. I dont want to change the formatting in the excel manually for the columns. When they look at the file for the first time, it should show properly.