Converting words to numbers

Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to 5 etc etc

I have found how to convert numbers to words but nothing on how to do the reverse

you could make a table
=VLOOKUP(G1,D1:E4,2,0)

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"vstromer77" <vstromer77.22tafn_1139235902.3939@excelforum-nospam.com> wrote
in message news:vstromer77.22tafn_1139235902.3939@excelforum-nospam.com...
>
> Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
> 5 etc etc
>
> I have found how to convert numbers to words but nothing on how to do
> the reverse
>
>
> --
> vstromer77
> ------------------------------------------------------------------------
> vstromer77's Profile:
> http://www.excelforum.com/member.php...o&userid=31217
> View this thread: http://www.excelforum.com/showthread...hreadid=508914
>

Try perusing this website containing custom functions:

http://www.ozgrid.com/VBA/ValueToWords.htm
--
Kevin Backmann


"vstromer77" wrote:

>
> Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
> 5 etc etc
>
> I have found how to convert numbers to words but nothing on how to do
> the reverse
>
>
> --
> vstromer77
> ------------------------------------------------------------------------
> vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217
> View this thread: http://www.excelforum.com/showthread...hreadid=508914
>
>

Somewhere amongst the advertising, there was a VBA procedure that does the
opposite of what the OP asked.

--
Regards,
Tom Ogilvy


"Kevin B" <kbackmann@sbcglobal.net.spamBgone> wrote in message
news:AF46D9DD-ACE4-49D0-9B0C-273E9C938510@microsoft.com...
> Try perusing this website containing custom functions:
>
> http://www.ozgrid.com/VBA/ValueToWords.htm
> --
> Kevin Backmann
>
>
> "vstromer77" wrote:
>
> >
> > Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
> > 5 etc etc
> >
> > I have found how to convert numbers to words but nothing on how to do
> > the reverse
> >
> >
> > --
> > vstromer77
> > ------------------------------------------------------------------------
> > vstromer77's Profile:
http://www.excelforum.com/member.php...o&userid=31217
> > View this thread:
http://www.excelforum.com/showthread...hreadid=508914
> >
> >