Forum Discussion
Excel NumToWords Formula
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.
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.
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
Perhaps, the attached sample file will help you understand how the formula works. Please look at the formula in B2, as shown in the snapshot below:
Twifoo Yes yes yes ..thank you so much, now the file that you sent works like a charm... what did you do.??? .just trying to understand and what i wasnt doing.....