How to get Excel CSV format in to write text cells in quotes?

J

jah

Past versions of Excel would put quotes around the text cells in the
speadsheet when I would "Save As" in a CSV format. Office XP doesn't seem to
be able to do that. I have programs that use that format and would like to
know if I can change something to make this work.
 
S

smw226 via OfficeKB.com

Hi Jah,

When you export from Access it still puts the "" around any text so, if you
have it, try importing your spreadsheet into it and then export it out again.

It is not an ideal solution but a work-around if your upagainst a deadline.

Thanks,

Simon
 
Top