numbertowords
 

Hi Friends,

please let me know how to use the function Numbertowords in excel. for
example we can convert $ 1,256. as one thousand two hundred & fifty six
dollars using this function.

thank you.

numbertowords
 

There is no direct functions to convert this. For a VBA solution check out
the below links

http://support.microsoft.com/kb/213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Jacob


"Thampoo" wrote:

Hi Friends,

please let me know how to use the function Numbertowords in excel. for
example we can convert $ 1,256. as one thousand two hundred & fifty six
dollars using this function.

thank you.

numbertowords
 

The xldynamic site also shows a non VBA solution.


---
HTH

Bob Phillips

"Jacob Skaria" wrote in message
...
There is no direct functions to convert this. For a VBA solution check out
the below links

http://support.microsoft.com/kb/213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Jacob


"Thampoo" wrote:

Hi Friends,

please let me know how to use the function Numbertowords in excel. for
example we can convert $ 1,256. as one thousand two hundred & fifty six
dollars using this function.

thank you.