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

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