| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a number to a text string
I want to convert a number like 12.56 to read Twelve Dollars and 56/100
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a number to a text string
Of all the (applicable) resources on the web, this is probably the easiest to
digest: http://www.xldynamic.com/source/xld.xlFAQ0004.html Regards, Ryan-- -- RyGuy "Sandy" wrote: I want to convert a number like 12.56 to read Twelve Dollars and 56/100 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a number to a text string
Thanks, I guess I'll wait til MS comes out with it
"ryguy7272" wrote: Of all the (applicable) resources on the web, this is probably the easiest to digest: http://www.xldynamic.com/source/xld.xlFAQ0004.html Regards, Ryan-- -- RyGuy "Sandy" wrote: I want to convert a number like 12.56 to read Twelve Dollars and 56/100 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a number to a text string
Hi Sandy,
Look he http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Sandy" wrote in message ... |I want to convert a number like 12.56 to read Twelve Dollars and 56/100 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a number to a text string
See Bob Phillips' site for methods.
http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 11:30:01 -0800, Sandy wrote: I want to convert a number like 12.56 to read Twelve Dollars and 56/100 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| convert string to number | Excel Worksheet Functions | |||
| convert a text string to a number | Excel Discussion (Misc queries) | |||
| convert text string to a number code | Excel Discussion (Misc queries) | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
Hybrid Mode
