Ron Coderre has updated his Convert Numbers to Words sample file, to fix some international issues that a user reported recently.
The file uses a VBA function to convert a number to words, with options to specify a major currency, such as dollars and a minor currency, such as cents.
The workbook has the following features:
- The NumsToWords() function, with parameters that allow you to change currencies and formats.
- A sample sheet that shows how to use the function's parameters.
- A button that will automatically export the NumToWords funtion into any open workbook. You don't have to know how to use VBA – just click the button, and the work is done for you!
_________________________
I prefer Laurent Longre's NBTEXT, since it has more options, including translation to 13 languajes and captioning.
SYNTAX :
=NBTEXT(Number,Language,Type,Unit1 (sing),Unit1 (plur),Unit2 (sing),Unit2 (plur),Style,Gender1, Gender2)
This function belongs to his MoreFunc add-in.
In the other hand, I wrote a single macro wich only converts the integral part, choosing between uper or lower case. You can see it at (posted in Spanish):
http://lqrexceltotal.blogspot.com/2009/02/convertir-numeros-letras.html
Regards.
This is a very nice VBA, quite similar to something which I've used previously. I have one issue with it though, which I seem unable to fix (my VBA skills are not the best).
I'm from Ireland, and on this side of the Atlantic, we speak numbers slightly differently than our American cousins. Whereas Americans (and probably many others) say "one hundred twenty three dollars" we would say "one hundred AND twenty three dollars (or Euro or pounds or ...)".
Unfortunately, it's not always as simple as having an AND after the hundred, i.e., "one hundred euro and twenty three cent". I've gotten lost trying to change the VBA, and I'm sure it's fairly simple, but I'd love to see if/how it could be done.
Thanks in advance.
It works!~ Thanks a lot! I'm looking for this for months and cannot sovle it!
Best Regards to you!
Lu Liang from China
Ron's VBA function works beautifully. Well thought out – making it easy to use. I have incorporated it into several files – saving me valuable time every week. Thanks!
After I have created the NumberAsText in one spreadsheet, how do I enable the
same to be used in other spreadsheet?
Regards,
Deepadevi
Thank you very much, works beautifully.
You made me look smart.
I like looking smart.
Thanks!
Dennis
You're welcome! Looking smart is a good thing. ;-)
I want to know the procedure. how can i change the dollar, to other currency.
Hi can u any one says how to convert numbers into words in Excel without macros?
(i.e. when i am entering the 5 display Five)
Thanks in advance..