Bill

Don't know why it's suddenly happened, but take the .csv off the file,
navigate to FilesOpen... and set files of type to all, navigate to the
file and this will open the text import wizard, you can set the delimiter as
comma via this route

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Bill" wrote in message
...
This used to work before but now whenever I import a .csv file (I've tried
each one that used to work before) entire records are being put into each
column variable but the commas are still there. There must be a setting
for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...

Anyplace else I can check?

thanks,
Bill