View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smw226 via OfficeKB.com smw226 via OfficeKB.com is offline
external usenet poster
 
Posts: 98
Default 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