Opening .csv document in text to columns

[Rodney]

When opening a .csv document, the information opens into one cell for each
row. I know I can choose Text to Column from the data menu and format the
information myself, but I would like it to open automatically in columns when
opening the file. How can I accomplish this within Excel?

 

[Dave Peterson]

First thing I'd check is the delimiter used in the .CSV file and the delimiter
that Windows uses.

In Win98:
Windows start button|settings|control panel|regional settings applet
Number Tab|List separator

Make them match.

Be aware that if you open a .csv file via a macro, then you'll want to use a
comma. VBA is very USA centric.