Twifoo

Jun 28, 2019Silver Contributor

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

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.