Forum Discussion

Twifoo's avatar
Twifoo
Silver Contributor
Jun 28, 2019

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.

metalarmy's avatar
metalarmy
Copper Contributor
thats correct..this is the formula NumToWords=IF(CellLeft<0,"Negative ","")&IntTxt&DecTxt
that I am entering in B1 and entering number 1234.56 in A1 and it shows nothing. Do i have to add anything before or after the formula or just the plain formula ? I am using Excel version 1908 from from microsoft office 365 pro plus
Twifoo's avatar
Twifoo
Silver Contributor
Dec 18, 2019

metalarmy 

Perhaps, the attached sample file will help you understand how the formula works. Please look at the formula in B2, as shown in the snapshot below: 

  • metalarmy's avatar
    metalarmy
    Copper Contributor
    Dec 18, 2019

    Twifoo Yes yes yes ..thank you so much, now the file that you sent works like a charm... what did you do.??? .just trying to understand and what i wasnt doing.....

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Dec 18, 2019

      metalarmy 

      I simply copied the formula in B2 of my original file to B2 of the new workbook with 1234.56 in A2. Perhaps, you copied the wrong cell. 

      • metalarmy's avatar
        metalarmy
        Copper Contributor
        Dec 18, 2019

        Twifoo ohh ok...I understood now...for so long i was copying the formula from B18 and pasting in a new workbook and then entering a number before it.... 😞 thank you so much dear...you help is really appreciated!! 

Resources