Comma delimited bank info
 

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany
schrieb im Newsbeitrag
oups.com...
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.

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

Jerry

Frank Kabel wrote:

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

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."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jerry W. Lewis" wrote in message
...
Rename is not necessary if instead of opening the .csv file, you open
Excel and use Data|Import External Data

Jerry

Frank Kabel wrote:

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

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?


Earl Kiosterud wrote:
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."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jerry W. Lewis" wrote in message
...
Rename is not necessary if instead of opening the .csv file, you
open
Excel and use Data|Import External Data

Jerry

Frank Kabel wrote:

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