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

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

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

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