initial post on possible problem with csv files

  • Thread starter Thread starter djc
  • Start date Start date
D

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.
 
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.
 
I'll check that out. Thanks.

Dave Peterson said:
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.
Click to expand...
 
Back
Top