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.

istiakahmed's avatar
istiakahmed
Copper Contributor
Jan 09, 2023
Hi Twifoo Sir,
Could you please help me on this regarding numbers to words without a VBA code

I need a formula for numbers to words without a VBA code. My currency is Taka instead of Dollars and after the decimal, it's called Paisa instead of Cent. Also require the word Only, in the last.
Here is the sample for a better understanding
1 = One Taka Only
10 = Ten Taka Only
10.50 = Ten Taka Fifty Paisa Only
100 = One Hundred Taka Only
1000 = One Thousand Taka Only
10000 = Ten Thousand Taka Only
100000 = One Lac Taka Only (We called Lac for one hundred thousand)
1000000 = Ten Lac Taka Only
10000000 = One Crore Taka Only

Please help me with this formula.

Thanks in advance.
  • tauqeeracma's avatar
    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.

     

     

    Thanks

    Tauqeer

    • istiakahmed's avatar
      istiakahmed
      Copper Contributor
      Jan 29, 2023
      Hi tauqeeracma,

      Thanks to you & Mr. specially to Mr. Twifoo for his continuous support for this kind of special formula. It's working fine in same sheet with "=@Conversion" in any cell next to the amount cell. But how it will work in a specific cell "

      Regards,
      Istiak Ahmed
      • tauqeeracma's avatar
        tauqeeracma
        Iron Contributor
        Jan 30, 2023

        istiakahmed 

        You are welcome.

         

        Just copy the formula (Conversion) and paste it next to any cell which contains the amount in numerals. 

        Even if you copy it to another file it will work.

         

        Thanks

        Tauqeer

    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Jan 12, 2023
      100,000 = One Lac Taka Only (We called Lac for one hundred thousand)

      ?
      not 1,000,000?
      • istiakahmed's avatar
        istiakahmed
        Copper Contributor
        Jan 29, 2023
        Hi peiyezhu,
        100,000 = One Lac Taka Only (We called Lac for one hundred thousand)
        1,000,000 = Ten Lacs.

Resources