| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to express a numerical in number words eg. 100 = one hundred
i want to automate a checking system in excel - i need a way of expressing a
numerical in to number words automatically - for example cell a1 is £11,503.63 want function so that cell a2 reads "Eleven thousand five hundred and three pounds and sixty three pence" Anyone know how to help? Thanks Paul |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to express a numerical in number words eg. 100 = one hundred
Paul,
http://www.ozgrid.com/VBA/CurrencyToWords.htm -- Hope that helps. Vergel Adriano "Paul Lynch" wrote: i want to automate a checking system in excel - i need a way of expressing a numerical in to number words automatically - for example cell a1 is £11,503.63 want function so that cell a2 reads "Eleven thousand five hundred and three pounds and sixty three pence" Anyone know how to help? Thanks Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number like(852) to words like(eight hundred fifty two) | Excel Worksheet Functions | |||
| How to show numbr in words like (100 = One Hundred ) | Excel Discussion (Misc queries) | |||
| How do I convert number 123 to text One Hundred and Twenty Three? | Excel Discussion (Misc queries) | |||
| How do I convert numerical into words ? | Excel Discussion (Misc queries) | |||
| change a number (100) to word (i.e Hundred) | Excel Discussion (Misc queries) | |||
Linear Mode
