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

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!! 

Twifoo's avatar
Twifoo
Silver Contributor
Dec 18, 2019
You’re very much welcome!
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 19, 2019
    Thank you sir
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Dec 19, 2019

    Saty_Rana 

    My NumToWords is a named formula, not a built-in function. You must copy B2 of my worksheet to B2 of yours to store the named formula into your Name Manager. Without copying B2, NumToWords won't work in your worksheet because it is not stored in your Name Manager. 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 19, 2019
    its working fine, but i want to know that why this formula works in your sheet by default, but not in mine? is there some reasona that i am not aware of? please tell

    regard
    Saty_Rana
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Dec 18, 2019
    As I stated earlier, you may test the formula by entering 1234.56 in A2 of your worksheet. Then, copy cell B2 in my original file and enter it in B2 of your worksheet.
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    why numer to words dont work on sheets made by me but works perfectly fine on your sheets sir

Resources