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.

tauqeeracma's avatar
tauqeeracma
Steel Contributor
Jul 11, 2019

Twifoo 

Outstanding work, really amazing and very much useful specially for finance people.

Tauqeer

Twifoo's avatar
Twifoo
Silver Contributor
Jul 11, 2019

tauqeeracma 

Thanks for your compliment. Incidentally, you need not copy the workbook. You only have to copy the formula to any cell other than those in Column A and it will convert the number to its left to words. 

Thereafter, you can convert any number in the same workbook by entering this formula in the cell to its right: 

=NumToWords

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

    Twifoo  

    Hi Twifoo Twifoo, not sure if i am entering the correct formula. I pasted the NumtoWords formula from your sheet then put a number eg. 345 but it did nothing. I would appreciate if you guide me how to use it. 

     

    Thank you in advance! 

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

      metalarmy 

      For example, enter 1234.56 in A1 of your worksheet. Copy the cell containing the NumToWords formula and enter it in B1. 

      You must see the words in B1 after that. 

      • metalarmy's avatar
        metalarmy
        Copper Contributor
        Dec 17, 2019
        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

Resources