CONVERT TEXT 2 NUMBERS
Yet another way is to add zero to the text value (as long as it is
purely made up of numbers):
=LEFT(A1,3)+0
Hope this helps.
Pete
On Oct 14, 12:23*pm, 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
|