| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert $10.10 to "ten and 10/100 dollars" ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert $10.10 to "ten and 10/100 dollars" ?
See Bob Phillips' site for methods.
http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP On Fri, 27 Apr 2007 13:12:00 -0700, GLH wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert $12.25 to "twelve and 25/100 dollars" in Excel? | Excel Discussion (Misc queries) | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
| "In Today's Dollars" help needed... | Excel Worksheet Functions | |||
| Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
Linear Mode
