Hello -

I am using Excel 2007 with Vista Home version

I have the MSN Money Stock Quotes add-in which works very well returning
quotes.
However, when I copy the data into my spreadsheet there is a reference,
like:

=MSNStockQuote($C14,"Volume","US")

What I want to do is change the cell value to a numerical value so I can
then use the data for addition or subtraction.

I can't seem to change this except by copying it by hand and then deleting
the formatting completely.

Is there a way to do this?

Thanks,
Paul

When you are ready to paste select Paste Special and select values.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Paul" wrote:

Hello -

I am using Excel 2007 with Vista Home version

I have the MSN Money Stock Quotes add-in which works very well returning
quotes.
However, when I copy the data into my spreadsheet there is a reference,
like:

=MSNStockQuote($C14,"Volume","US")

What I want to do is change the cell value to a numerical value so I can
then use the data for addition or subtraction.

I can't seem to change this except by copying it by hand and then deleting
the formatting completely.

Is there a way to do this?

Thanks,
Paul

Thank you, that worked fine. Sincerely, Paul


"Michael" wrote in message
...
When you are ready to paste select Paste Special and select values.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Paul" wrote:

Hello -

I am using Excel 2007 with Vista Home version

I have the MSN Money Stock Quotes add-in which works very well returning
quotes.
However, when I copy the data into my spreadsheet there is a reference,
like:

=MSNStockQuote($C14,"Volume","US")

What I want to do is change the cell value to a numerical value so I can
then use the data for addition or subtraction.

I can't seem to change this except by copying it by hand and then
deleting
the formatting completely.

Is there a way to do this?

Thanks,
Paul