Convert Alphabets to Numeric

Hi! all

Am using MS Office 2007,
I have some strings with values as alphabets
and i have a long list..... and i need them to converted to Numeric
can someone please help me to automate this process

Example:

Seven Hundred Fifty Thousand Eight Hundred Fifty Eight
Five Hundred Ninety Two Thousand Five Hundred Forty
Seven Hundred Seventy Six Thousand Nine Hundred Nine
Eight Hundred Seventeen Thousand Sixty
Seven Hundred Eighteen Thousand Nine Hundred Fifty Five
Nine Hundred Seventy Two Thousand Four Hundred Twelve


Desired Result

EG:

750858
592540
776909
817060
718955
972412

Appreciate you early reply

Hi!


I need the vice versa...

Alphabet to Numeric values.......

Originally Posted by msexcelathome

Here!

Check this out -

http://support.microsoft.com/kb/213360

http://www.excelforum.com/excel-prog...an-format.html - Indian Format

You might have to tweak the code a bit as required

Deep

Thanks you for the link.

But there are some error........
as you can see in the last post by kjxavier

Originally Posted by JBeaucaire

See here: http://www.excelforum.com/excel-gene...ml#post3757635