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
|