dealing with csv imported file in excel

[malex050]

I have imported csv file(stocks data) from yahoo into mine excel 2003
sheet but i can't perform
calculations with it because the formats doen' t match,does anyone how
to deal with csv imported
files into excel sheet so that you could perform calculation with the
imported data?

 

[Gord Dibben]

You could try one or two methods.

1. Format all to General. Copy an empty cell then select your range of data.
Edit>Paste Special>Add>OK>Esc

2. Data>Text to Columns>Next>Next>Column Data Type>General>Finish


Gord Dibben MS Excel MVP

 

[David Biddulph]

I have imported csv file(stocks data) from yahoo into mine excel 2003
sheet but i can't perform
calculations with it because the formats doen' t match,does anyone how
to deal with csv imported
files into excel sheet so that you could perform calculation with the
imported data?

You may wish to try renaming your CSV file as .TXT, then the import wizard
will give you a choice of format for each column.