Missing double quotes when opening .CSV file from notepad

  • Thread starter Thread starter adam
  • Start date Start date
A

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-
 
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.
 
Back
Top