Forum Discussion
Excel NumToWords Formula
- 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.
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!
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.
- metalarmyDec 17, 2019Copper Contributorthats 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