Change number (in text format) to numeric format
Try
=--(TRIM(F2))
if that doesn't work then you have html trailing spaces
=--(TRIM(SUBSTITUTE(F1,CHAR(160),"")))
--
Regards,
Peo Sjoblom
"Pam" wrote in message
...
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?
|