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.

Soundra04's avatar
Soundra04
Copper Contributor
Dec 23, 2019

In the attached file I need to enter the month in the first tab where I have highlighted which should pick the month in second tab and post the total from the third tab to the second tab in the appropriate month.

 

Can you help me please?

 

Kind Regards

 

Soundra Lawrence

mathetes's avatar
mathetes
Silver Contributor
Dec 23, 2019

Soundra04 

 

You need to post this as the start of a new thread. It is not a continuation of the existing conversation....

However, now that I've taken a few minutes to look at that workbook, I would suggest you go back to whoever it was that designed it and ask for clarification (and fixes) there. It's clearly meant as a template for personal cash flow management, but is not fully functional at this point (unless you inadvertently made changes to it that adversely affected it).

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Dec 23, 2019
    Perfect suggestion!

Resources