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


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