Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use displayed value, not stored value? | Excel Worksheet Functions | |||
Currency displayed as full text | Excel Discussion (Misc queries) | |||
Currency Style button | Excel Discussion (Misc queries) | |||
How to convert currency into words? | Excel Discussion (Misc queries) | |||
convert currency in portuguese words | Excel Worksheet Functions |