viewing CSV file in Excel-2000

[aa]

I 've got my bank statement as a CSV text file but my Excel2000 fails to
recognise comma as a fiel separator and places each record into a single
cell. How do I get round this?

 

[Bernard Liengme]

Select the column, use Date>Text-to-Columns, Delimited and specify comma
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

 

[Dave Peterson]

Excel uses the windows separator for its list separator.

You could go into the control panel|regional settings and make the list
separator the comma. But since this is a windows setting, you may find you've
caused other problems.

Alternatives would be to rename the .csv file to .txt and when the import data
wizard appears (after you do File|Open), you can specify that it a text file
delimited by commas.

Or since the data is in a single column already, just select that column and use
Data|Text to columns. Then choose delimited by a comma.

 

[aa]

Thank you very much