Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting currency to text "One & 00/100 Dollars"
mkane, 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 "mkane" wrote in message ... I've been looking for a function or format that would convert currency to text to automate our company check request forms. Specifically, I would reference a field with currency input such as $1120.35 and display that in a seperate field as "One Thousand One Hundred Twenty & 35/100" Seems like there would have to be a function for this - any help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with "Currency Convert to Text" | Excel Worksheet Functions | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions |