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

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.

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

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

jah wrote:
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.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com