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.

NumToWords.xlsx10 KB

excel

Formulas and Functions

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.
NumToPounds.xlsx10 KB

tauqeeracma

Iron Contributor

Jan 12, 2023

Hi istiakahmed

NumToWords template designed by the respected expert member Mr. Twifoo is based on an international number system (Unit/Ten/Hundred/Thousand etc.), whereas you need the conversion of numbers into words based on your local (Bangla/Taka) numbering system.

I have modified the attached file and hope it will address your requirements.

Please go through it and let me know if it works for you.