| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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  -- vstromer77 ------------------------------------------------------------------------ vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217 View this thread: http://www.excelforum.com/showthread...hreadid=508914 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- vstromer77 ------------------------------------------------------------------------ vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217 View this thread: http://www.excelforum.com/showthread...hreadid=508914 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- vstromer77 ------------------------------------------------------------------------ vstromer77's Profile: http://www.excelforum.com/member.php...o&userid=31217 View this thread: http://www.excelforum.com/showthread...hreadid=508914 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| words means numbers | Excel Worksheet Functions | |||
| Numbers converted into amount in words in English? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
| converting copied data to numbers in excel xp | New Users to Excel | |||
Linear Mode
