Missing double quotes when opening .CSV file from notepad

[adam]

Hi Expert,

Before when I saved an Excel file to .CSV format and open it from notepad,
it automatically adds double quotes to cell values, such as:
"abc", "def","xyz"

I don't know when this feature disappeared. I am using office 2003.
It now shows without double quotes as follows:
abc,def,xyz

Any idea how to get this feature back.

Thanks,

-adam-

 

[Earl Kiosterud]

Adam,

The quote marks aren't usually needed, unless your data has quotes in it already, or commas.
You can read up on it at http://www.smokeylake.com/excel/textfiles.htm. Read the section
titled "Delimited test file." If you're sure you need the quote marks for all fields, use
the Text Write Program, at that site. It can be configured to do so.