Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing text to numerals
Is there a quick and easy way of changing numbers enter as text (i.e. one,
two, three) to numerals. I have a whole column of numbers entered in text form that I need to convert! Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing text to numerals
What is the "range" of the the text i.e. is it simply "one"," two ","three"
or [for example) "one hundred and tweny four"? "JRD" wrote: Is there a quick and easy way of changing numbers enter as text (i.e. one, two, three) to numerals. I have a whole column of numbers entered in text form that I need to convert! Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing text to numerals
Use VLOOKUP:
for example, in cols C & D enter: one 1 two 2 three 3 four 4 five 5 six 6 seven 7 eight 8 nine 9 ten 10 and in B1 enter: four then the following formula: =VLOOKUP(B1,C:D,2,0) will return the number 4 -- Gary's Student "JRD" wrote: Is there a quick and easy way of changing numbers enter as text (i.e. one, two, three) to numerals. I have a whole column of numbers entered in text form that I need to convert! Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing text to numerals
Thank you. That worked
"Gary''s Student" wrote: Use VLOOKUP: for example, in cols C & D enter: one 1 two 2 three 3 four 4 five 5 six 6 seven 7 eight 8 nine 9 ten 10 and in B1 enter: four then the following formula: =VLOOKUP(B1,C:D,2,0) will return the number 4 -- Gary's Student "JRD" wrote: Is there a quick and easy way of changing numbers enter as text (i.e. one, two, three) to numerals. I have a whole column of numbers entered in text form that I need to convert! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) | |||
How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
changing text case | New Users to Excel | |||
Make Excel changing text case as easy as in Word!! | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |