=--A1

Where A1 houses your textual numbers. Also, ASAP Utilities has a good
feature for converting textual numbers into numerical numbers.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"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?