Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers stored as numbers to text | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
convert numbers to text. | Excel Worksheet Functions | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |