| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting currency to text "One & 00/100 Dollars"
I use this one. It does spell out the cents though. =fSpellNumber(B16, 1, "Dollar") B16 is the cell I have the actual number in. mkane wrote: 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) | |||
| Converting currency to text "One & 00/100 Dollars" | Excel Programming | |||
| 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 | |||
![RealmSteel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
