Thread
:
Converting number to text
View Single Post
#
2
June 2nd, 2010, 06:17 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
Posts: 5,952
Converting number to text
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 (MVP - Excel)
"booshi" wrote:
Is it possible to convert, say 1234 to one thousand two hundred and thirty
four
Thanks
.
Jacob Skaria
View Public Profile
View message headers
Find all posts by Jacob Skaria
Find all threads started by Jacob Skaria