Forum Discussion

Twifoo's avatar
Twifoo
Silver Contributor
Jun 28, 2019
Solved

Excel NumToWords Formula

To revel my 20th week as a member of this EXCELlent Community, I hereby share my NumToWords formula. Delve into it in the attached file and please apprise me of your thoughts thereon.
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Aug 28, 2020

    Jay8642, your request is my command! Note that I simply edited the formulas for these defined names: 

    1. CurName

    =IF(INT(IntNum)=0,"","Pound"&LEFT("s",INT(IntNum)>1))

     

    2. DecName

    ="Pen"&IF(SIGN(DecNum-1),"ce","ny")

     

    Finally, I renamed NumToDollars as NumToPounds. To satisfy your curiosity on the process of constructing the formula, you can read my articles on NumToWords and NumToDollars. The snapshot below illustrates the use of the NumToPounds formula: 

    The Excel file containing the NumToPounds formula is hereto attached for the benefit of those who may be interested in testing its usage.

mathetes's avatar
mathetes
Silver Contributor
Dec 18, 2019

Twifoo 

 

That's great. And congratulations on your twentieth week! I think I'm in my fourth or fifth, and loving it too.

 

Your formula here takes me back to my earliest days with a PC...probably the late 70s.. I wrote a program (Basic) to print checks to pay bills; got a supply of checks that would go through a pin-feed, dot matrix Okidata printer.

And I wrote a routine that would translate 123.45 into "One Hundred Twenty-Three Dollars and Forty-five Cents"   One feature of which I was very proud was that if the amount was, say, 1.14, the words would be "One Dollar" --- in the singular-- and same for "One Cent" if it came to that. None of that settling for "Dollars" just because that 99.9% of the time would work accurately. I notice you left off the currency label, which makes it more universal, so no problem.

But fun, right?

Thanks for sharing it.

Twifoo's avatar
Twifoo
Silver Contributor
Dec 19, 2019

mathetes 

Thanks for your compliment. My formula is universal, such that, as its name connotes, it converts a number to words, not to a specific currency. You're right, it was fun constructing the formula. 

By the way, the formula is broken down into components to enable modification of each to convert a number to a specific currency. 

Cheers, 

Twifoo

Resources