Does anyone know a way to get excel to not include quotations in a value?
I have the formula:
=WEBSERVICE("http://finance.yahoo.com/d/?s="&A3&"&f=p2")
so that I can pull the % Change in a Stock price from Yahoo finance.
It pulls the number back as "+0.15". the quotations are preventing me from throwing the =NumberValue
formula in front of that one so that I can format the cells.
I have the same formula (just a tab bit different URL) for Change in price and it doesn't put quotations around it.