initial post on possible problem with csv files

[djc]

I don't have all the info yet but before I spend any time on this is there
any known issues with Excel 2002 sp2 opening .csv files incorrectly? I have
a report of a csv file opening fine in excel 97 but the same file is not
formatted correctly when opened in Excel 2002 sp2... apparently all data
gets stuffed into one column instead of it correctly separating columns
according to the comma delimited file.

any info would be greatly appreciated.. thanks.

 

[Dave Peterson]

Maybe it's not excel that's really at fault.

You may want to look at your regional settings and make sure that the separator
inside the file matches the list separator in the regional settings.

In win98, I can get to the regional settings applet via:

Windows Start Button|Settings|Control panel|regional settings applet|

Then look at the Number tab.

 

[djc]

I'll check that out. Thanks.

Maybe it's not excel that's really at fault.

You may want to look at your regional settings and make sure that the separator
inside the file matches the list separator in the regional settings.

In win98, I can get to the regional settings applet via:

Windows Start Button|Settings|Control panel|regional settings applet|

Then look at the Number tab.