| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert currency to text in Excel ($2,000 to Two Thousand)
Is there a way to convert a currency value such as $2,000 in one column to a
narrative value of "two thousand" in another column? If so, will it work for included decimal values; $2,000.20? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert currency to text in Excel ($2,000 to Two Thousand)
See Bob Phillips' site for methods.
http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 08:56:01 -0800, Brinton wrote: Is there a way to convert a currency value such as $2,000 in one column to a narrative value of "two thousand" in another column? If so, will it work for included decimal values; $2,000.20? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the numerical to text (ie 1200 to One thousand two | Excel Discussion (Misc queries) | |||
| How to convert Value to words?Eg.Rs.1000/- to Repees One thousand | Excel Discussion (Misc queries) | |||
| convert currency to text | Excel Discussion (Misc queries) | |||
| How do I convert numbers to words (1000 to One Thousand) in Excel | Excel Discussion (Misc queries) | |||
| I want to convert 10,000 to "Ten Thousand" using Excel Function | Excel Worksheet Functions | |||
Linear Mode
