View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default dealing with csv imported file in excel

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