Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

convert number into words

234 views
Skip to first unread message

manzoor

unread,
May 28, 2003, 3:50:47 AM5/28/03
to
I want to change the numbers into words like this
FUNCTION(number)="..In Words .."
ie FUNCTION(123)="One Hundred Twenty Three"
FUNCTION(1024)="One Thousand Twenty Four"
FUNCTION(212546)="Two Lakh Twelve Thousand Five Hundred
Fourty Six"

David McRitchie

unread,
May 28, 2003, 4:08:07 AM5/28/03
to
Strings and Manipulations
http://www.mvps.org/dmcritchie/excel/strings.htm

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...

Andy Wiggins

unread,
May 28, 2003, 5:00:11 AM5/28/03
to
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

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...

Shailesh Shah

unread,
May 28, 2003, 7:50:35 AM5/28/03
to
Hi,

>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!

Orlando Magalhães Filho

unread,
May 31, 2003, 12:17:57 AM5/31/03
to
Hi manzoor,

Look for "VBA spell numbers function" at this site:

http://cpap.com.br/orlando


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...

0 new messages