Excel Text to number conversionST
First some background
So I got bored and decided I wanted to look for sites that graphically tracked the change in a stocks EPS over time. I really want to track atleast 5 years worth of data so I have enough data points. www.earnings.com gives me the necessary data however when i cut and paste the earnings history into excel for some reason the earnings figures are pasted as text or something that doesnt allow me to treat them as I otherwise a number.
I want to add A1 and A2, however when i do it simply displays it as #VALUE
I have tryed using text to column, I have tryed multiplying the selected cells by 1, and i have even tryed the following macro.
For Each xCell In Selection
xCell.Value = xCell.Value
How do I convert these so i can run operations on the data?! Thanks.