I just use the following

If my 'text' number is in A1

in B1 I have the formula

= A1 + 0

works like a charm..

"timtak" wrote:


Thanks.

I did not know the meaning of "special paste add"

But it would be nice to know how to do the same with an excel function.


Is there something like
=num(a1)
which would turn a string, even a string, even a null string into ta
number?

There is no need to answer my post since I used the paste function
suggested.
But to say thank you and for the sake of future viewers I leave you all
with this
question.

Thanks again,
Tim


--
timtakPosted from http://www.pcreview.co.uk/ newsgroup access