Missing double quotes when opening .CSV file from notepad

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

adam - 19 May 2008 22:02 GMT

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-

Reply to this Message

Earl Kiosterud - 19 May 2008 22:43 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Hi Expert,
>
[quoted text clipped - 11 lines]
>
> -adam-

Reply to this Message