XL's default csv format will put quotes around data that includes quotes.
If you still want every field to have quotes, take a look at
http://www.mcgimpsey.com/excel/textf...#csvwithquotes
In article ,
"Marc" wrote:
I need to export an excel spreadsheet to CSV but I need every field to have
quotes around it because some of the fields have a comma as part of their
value, is their anyway to do this.