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 :confused:


--
vstromer77
------------------------------------------------------------------------
vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217
View this thread: http://www.excelforum.com/showthread...hreadid=508914

Converting words to numbers
 

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

--
Don Guillett
SalesAid Software

"vstromer77" wrote
in message ...

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 :confused:


--
vstromer77
------------------------------------------------------------------------
vstromer77's Profile:
http://www.excelforum.com/member.php...o&userid=31217
View this thread: http://www.excelforum.com/showthread...hreadid=508914

Converting words to numbers
 

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 :confused:


--
vstromer77
------------------------------------------------------------------------
vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217
View this thread: http://www.excelforum.com/showthread...hreadid=508914

Converting words to numbers
 

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

--
Regards,
Tom Ogilvy


"Kevin B" wrote in message
...
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 :confused:


--
vstromer77
------------------------------------------------------------------------
vstromer77's Profile:
http://www.excelforum.com/member.php...o&userid=31217
View this thread:
http://www.excelforum.com/showthread...hreadid=508914