CONVERT TEXT 2 NUMBERS
 

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

CONVERT TEXT 2 NUMBERS
 

=--(LEFT(A1,2))

Hope this helps.
--
John C


"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

CONVERT TEXT 2 NUMBERS
 

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

CONVERT TEXT 2 NUMBERS
 

Hi,

With this in A1
q2q

=Mid(a1,2,1)
extracts the 2 and you can still do arithmatic on it

If you want it to right justify like a number multiply it by 1

=Mid(a1,2,1)*1

Mike


"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

CONVERT TEXT 2 NUMBERS
 

use =value(left(text,num_char))


On Oct 14, 4: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

CONVERT TEXT 2 NUMBERS
 

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

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