Am trying to find a function that will convert a dollar amount to a text description, i.e. "$5.25" to "Five Dollars and 25/100" (quotes for emphasis only). Any ideas where I could find it??![]()
Am trying to find a function that will convert a dollar amount to a text description, i.e. "$5.25" to "Five Dollars and 25/100" (quotes for emphasis only). Any ideas where I could find it??![]()
Last edited by VBA Noob; 05-17-2008 at 12:46 PM.
There load of examples on the net but not in your format
Under Functions -Convert Numbers to Words
http://support.microsoft.com/kb/213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.meadinkent.co.uk/xlnumberstext.htm
Under Accountants - num2wrds
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks