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


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