Comma delimited bank info

[Trashbagl]

Excel 2000 Sp 2, Windows 5.1 Sp2
If I download my bank statement as a comma delimited file I get a *.csv
file with each comma delimited field placed in a separate field: Date,
Description, Withdrawal, Deposit, Balance, which is exactly as I
require it. However, I usually work in a foreign language Windows and
Excel and there instead of the separate fields I get one field with all
the infomation including the commas. My guess is that I'm missing a
converter or haven't checked an option that's needed. Can someone
be kind enough to guide me to the settings I need? Thanks.

 

[Frank Kabel]

Hi
I'd guess this PC has different regional settings (check: Start-menu -
Control Panel - Regional settings).
One workaround: Rename the file to *.txt and open it afterwards with Excel.
Now the textimport wizuard should start and you can define the coma as
delimiter

 

[Jerry W. Lewis]

Rename is not necessary if instead of opening the .csv file, you open
Excel and use Data|Import External Data

Jerry

 

[Earl Kiosterud]

Very true. And depending on your release of Excel, you get different
importing capabilities. For repeated importing of the data, Excel 2002 and
up is good. See www.smokeylake.com/excel for details. Read "Text files and
Excel."

 

[Trashbagl]

Thanks for the suggestions, fellows. Two problems:
1. When I use Data|Import External Data I still get I get one field for
each record with all the infomation, including the commas.
2. Compared to the one click that opens a *.csv file with each comma
delimited field placed in a separate field, ready for a simple copy and
paste, importing external data needs many clicks for a place to save
the file and many clicks in the data import wizard. Then I have a *.csv
on disk that I have to remember to delete.
I suspect there's an add-in I haven't installed or an options
setting I haven't checked. Any ideas?