Does anyone know a way to get excel to not include quotations in a value?
I have the formula:
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.