The easy option is to use the double unary minus.

=LEFT(A2) gives text, but =--LEFT(A2) would give a number (providing, of
course, that the text was numerical).
--
David Biddulph

"FARAZ QURESHI" wrote in message
...
I have used quite some scheme of formulas like left(), right() to extract
the
"numbers" from a list of codes but they turn out to be in text form. Any
idea
how to use some sort of =Text() like function so as to convert the
extracted
figures to numbers?

--
Best Regards,
FARAZ A. QURESHI