how can currency be displayed as words
How can a numeric amount be displayed as words as would be shown on a check?
eg. cell A1 = 53.67 cell A2 = +A1 result A2 = Fifty-three and 67/100 Dollars (this can be in Quattro-Pro with the @dollartext function) |
Duane, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Duane Why" <Duane wrote in message ... How can a numeric amount be displayed as words as would be shown on a check? eg. cell A1 = 53.67 cell A2 = +A1 result A2 = Fifty-three and 67/100 Dollars (this can be in Quattro-Pro with the @dollartext function) |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com