software

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: www.excelforum.com/member.php...oamp;userid=31217
View this thread: www.excelforum.com/showthread...hreadid=508914you could make a table
=VLOOKUP(G1,D1:E4,2,0)

--
Don Guillett
SalesAid Software

quot;vstromer77quot; gt; wrote
in message ...
gt;
gt; Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
gt; 5 etc etc
gt;
gt; I have found how to convert numbers to words but nothing on how to do
gt; the reverse
gt;
gt;
gt; --
gt; vstromer77
gt; ------------------------------------------------------------------------
gt; vstromer77's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31217
gt; View this thread: www.excelforum.com/showthread...hreadid=508914
gt;
Try perusing this website containing custom functions:

www.ozgrid.com/VBA/ValueToWords.htm
--
Kevin Backmannquot;vstromer77quot; wrote:

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

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

--
Regards,
Tom Ogilvyquot;Kevin Bquot; gt; wrote in message
...
gt; Try perusing this website containing custom functions:
gt;
gt; www.ozgrid.com/VBA/ValueToWords.htm
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;vstromer77quot; wrote:
gt;
gt; gt;
gt; gt; Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
gt; gt; 5 etc etc
gt; gt;
gt; gt; I have found how to convert numbers to words but nothing on how to do
gt; gt; the reverse
gt; gt;
gt; gt;
gt; gt; --
gt; gt; vstromer77
gt; gt; ------------------------------------------------------------------------
gt; gt; vstromer77's Profile:
www.excelforum.com/member.php...oamp;userid=31217
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=508914
gt; gt;
gt; gt;