Numbers to words (as in check protection wording)
Q213360 - XL2000: How to Convert a Numeric Value into English Words in Dollars and Cents
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q213360
See KB Article Number Q140704 in Dollars and Cents
http://support.microsoft.com/default.aspx?scid=kb;en-us;q140704
See KB Article Number Q95640 One Thousand Two Hundred Thirty Four Dollars And Fifty Six Cents
http://support.microsoft.com/default.aspx?scid=kb;en-us;q95640
Dollars Function by Bernie Deitrick (works up to trillions) gives you a choice with or without "Dollars and Cents" wording.
=Dollars(111.11, TRUE) produces One Hundred Eleven Dollars And 11/100
=Dollars(111.11, FALSE) produces One Hundred Eleven and 11/100
http://groups.google.com/groups?as_umsgid=3B682245...@consumer.org
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"manzoor" <mmm_si...@yahoo.com> wrote in message news:3f4201c324ed$d9c2d7a0$a301...@phx.gbl...
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.
The code is open and commented.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"
"manzoor" <mmm_si...@yahoo.com> wrote in message
news:3f4201c324ed$d9c2d7a0$a301...@phx.gbl...
>FUNCTION(212546)="Two Lakh Twelve Thousand Five Hundred
Fourty Six"
E mail me, I have written one free add-ins to convert numbers into
Indian Rupees in Words and convert Number format(Positive Numbers) to
Indian Number System.
Regards,
Shah Shailesh
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Look for "VBA spell numbers function" at this site:
HTH
---
(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)
"manzoor" <mmm_si...@yahoo.com> escreveu na mensagem
news:3f4201c324ed$d9c2d7a0$a301...@phx.gbl...