dealing with csv imported file in excel

  • Thread starter Thread starter malex050
  • Start date Start date
M

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?
 
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
 
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?
Click to expand...

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.
 
Back
Top