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 could try one or two methods.

1. Format all to General. Copy an empty cell then select your range of data.
EditPaste SpecialAddOKEsc

2. DataText to ColumnsNextNextColumn Data TypeGeneralFinish


Gord Dibben MS Excel MVP

On 24 Jul 2006 11:46:13 -0700, wrote:

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?

wrote in message
oups.com...
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.
--
David Biddulph