Convert Number to Words In Excel

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.

ConvertNum

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!

_________________________

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

11 comments to Convert Number to Words In Excel

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

  • The.Q

    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.

  • Owen

    It works!~ Thanks a lot! I'm looking for this for months and cannot sovle it!

    Best Regards to you!

    Lu Liang from China

  • Jim

    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!

  • Deepadevi

    After I have created the NumberAsText in one spreadsheet, how do I enable the
    same to be used in other spreadsheet?

    Regards,
    Deepadevi

  • Juliana

    Thank you very much, works beautifully.

  • Dennis

    You made me look smart.

    I like looking smart.

    Thanks!

    Dennis

  • You're welcome! Looking smart is a good thing. ;-)

  • yort rosal

    I want to know the procedure. how can i change the dollar, to other currency.

  • Vinayak

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

  • Richard Wilson

    Is there a way to make negative numbers show "left" and positive numbers show "right"? Thanks in advance!!!

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>