one way;
In a blank cell enter the number 1. Now copy and highlight the range you
want to convert to numbers. Editpaste special multiply
hth


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