Use the =VALUE(TextValue) to convert numbers appearing as text to their
numeric value. The example below converts the test string in A1 to a value:

=VALUE(A1)


--
Kevin Backmann


"FARAZ QURESHI" wrote:

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