Change number (in text format) to numeric format
Thanks for all your suggestions, but none of them helped in this particular
file. :(
However, I was able to do a VLOOKUP and that worked. (The VLOOKUP table had
the 'number' as text in the first column and then the 'real' number was in
the 2nd column.) That worked.
"Pam" wrote:
I have numbers in a column. But they aren't 'real' numbers (to Excel), they
just look like numbers to the naked eye. So, of course, I can't do any
numeric functions on these 'numbers'.
I went to help and I see the =VALUE function which looks like that would be
my answer.
But, when I type: =VALUE(F2) I get #VALUE! instead of the number I want-- 0.13
Any ideas?
|