csv file does not open correctly in Excel

[blom0344]

Using Excel 97 a comma separated .csv file will not properly open in Excel by double-clicking the file. If I change the seperator with a semi-colon, the file opens correctly. In Excel 2000 I can do an import on the .csv file and use a wizard to import it properly. There seems to be no option in Excel 97 like that..........
Is there a work-around for this behavior, should I change some Excel or regional settings?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Dreamboat]

Is this a one-time or many-time need?

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[blom0344]

Absolutely many time need.........

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Dreamboat]

Have you associated *.csv files to Excel?

Shift and Right-click any CSV.
Choose Open With.
Choose Excel.
Hit the checkbox to "always use this program..."
Hit OK.

What's your OS?


Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[blom0344]

We are working both with W2000 and W98 second edition.
Our users work with Office 97.
The problem is not that .csv files do not open with Excel when double-clicking, in fact they do alright. Excel however does not recognize the comma seperator, and imports the entire row into one cell. Changing the comma into a semi-colon somehow does the trick..........

T. Blom
Information analyst
tbl@shimano-eu.com