| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for returning the amount to amount in words
what is the formula for returning the amount to amount in words
For Example : in cell A1, if the value entered is USD 1,500 I need a formula which will give the amount in words for the given value i.e. the answer should be USD One Thousand Five Hundred only |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what is the formula for returning the amount to amount in words
There is no direct functions to convert this. For a VBA solution check out
the below links http://www.ozgrid.com/VBA/ValueToWords.htm http://support.microsoft.com/kb/213360 http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Jacob "Vijay" wrote: what is the formula for returning the amount to amount in words For Example : in cell A1, if the value entered is USD 1,500 I need a formula which will give the amount in words for the given value i.e. the answer should be USD One Thousand Five Hundred only |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
| formula which can convert amount in figures to amt in words | Excel Worksheet Functions | |||
| Amount in Words Complete Right Formula | New Users to Excel | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
Linear Mode
