| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Format text across cells | New Users to Excel | |||
Linear Mode
