Just some comments/questions...

First, I'd double check the regional settings list separator character--no extra
trailing space characters/junk(?).

Second, if you save the file to a .csv file on your harddrive and then
doubleclick on that filename in windows explorer, does excel open it correctly
(separate columns for each field)?

Third (just a guess), I think I'd try to reregister excel so that it knows that
it owns the .csv extension.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Then test it out.

Good luck,


Les M wrote:

I have recently upgraded to Windows XP Home edition and have reinstalled all
my applications. I regularly download csv files from one particular site and
use them in Excel, but now they always download with all data in column A (in
the past they downloaded correctly as csv files, using separate columns).

In Control panel/Regional settings, comma is specified as the list
separator, but this is not having the required effect.

I can go through the "Data/Text to Columns/Delimited/comma" process each
time I download (and that process works), but I would like the default to
operate as it should.

Any helpful advice would be appreciated.

--

Dave Peterson