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.

MarekKoppel's avatar
MarekKoppel
Copper Contributor
May 03, 2020

Twifoo 

 

I'll get help. I hope you help me (although I know I'm at the computer level). I'm not ashamed of my ignorance. Because really: "The world is full of opposites.".

 

I only do Excel calculations for myself. I have a problem with one calculation. Specifically: the same numbers, but the same function, but the result is different in both equivalent calculations. If only I knew what the correct function must be to get the right result (and it's the same number in both identical operations). I will send you a file (Microsoft Office Home and Student 2013). Will you send me back the correct formula.

 

I watched the "Excel NumToWords Formula" level. I saved your NumWords.xlsx file. The function works! How, I do not understand… but I say only to myself: I am learning!

Twifoo's avatar
Twifoo
Silver Contributor
May 03, 2020
I recommend that you post your problem as a new conversation so that you could obtain more solutions.

Resources