dealing with csv imported file in excel

[[email protected]]

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

On 24 Jul 2006 11:46:13 -0700, [email protected] 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?

[David Biddulph]

<[email protected]> wrote in message
news:[email protected]...
>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