Not sure if I am in the right place here.

Trying to manipulate Yahoo historical stock price data
which downloads in spreadsheet format and looks like this:
(imagine columns)

^DJI 02/10/95 4890.0 4896.2 4889.2 4895.6

I need the data in .txt format and to look like this:

^DJI,19951002,4890.0,4896.2,4889.2,4895.6

I am not hopeful on this one but some of you smart guys
may have an idea.

Thanks in advance.

Michele

You can import the existing file into Excel. In the Text File Wizard, specify
that the data is delimited, and the delimiter is a space.

Once you've done that, then just do a File/Save As, and select CSV from the
"Save As Type" box.

On Sun, 10 Oct 2004 21:35:37 -0700, "Michele"
wrote:

Not sure if I am in the right place here.

Trying to manipulate Yahoo historical stock price data
which downloads in spreadsheet format and looks like this:
(imagine columns)

^DJI 02/10/95 4890.0 4896.2 4889.2 4895.6

I need the data in .txt format and to look like this:

^DJI,19951002,4890.0,4896.2,4889.2,4895.6

I am not hopeful on this one but some of you smart guys
may have an idea.

Thanks in advance.

Michele