Change cell references
 

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

Change cell references
 

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

Change cell references
 

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