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