Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to update/change cell references in a formula | Excel Discussion (Misc queries) | |||
change view of cell references | Excel Discussion (Misc queries) | |||
Macro Auto Change Cell References | Excel Programming | |||
how do I change cell references in a column | Excel Worksheet Functions | |||
Excel change SUM references if you cut & paste the first cell in SUM... | Excel Discussion (Misc queries) |