Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|