I am encountering two issues with Salesforce integration into MS EXCEL. 

1.  When I run a report and export it as either CSV or XLS file extentions my date fields export out as a mix of General text or Date/time and I can not work with them in EXCEL (even after resaving the files as a differently named XLS file and changing the field formats to date/time).

2.  When I select csv as the export file type, the data exports out as 1 record across many columns per row instead of 1 record per row per column with comma's seperating the values.

Any Idea on how to resolve this?

thanks,

Mel

I am encountering two issues with Salesforce integration into MS EXCEL. 

1.  When I run a report and export it as either CSV or XLS file extentions my date fields export out as a mix of General text or Date/time and I can not work with them in EXCEL (even after resaving the files as a differently named XLS file and changing the field formats to date/time).

2.  When I select csv as the export file type, the data exports out as 1 record across many columns per row instead of 1 record per row per column with comma's seperating the values.

Any Idea on how to resolve this?

thanks,

Mel