| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Convert $12.00 to text (Twelve dollars) like you would on a chec..
Can Excel convert a number ($12.00) in one cell and display it as text
(Twelve and 00/100) in another? Similar to writing a check, proposal, etc... |
|
#2
|
|||
|
|||
|
Hi Dave
See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Regards Ron de Bruin http://www.rondebruin.nl "Dave" wrote in message ... Can Excel convert a number ($12.00) in one cell and display it as text (Twelve and 00/100) in another? Similar to writing a check, proposal, etc... |
|
#3
|
|||
|
|||
|
Thanks Ron
Worked perfectly! "Ron de Bruin" wrote: Hi Dave See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Regards Ron de Bruin http://www.rondebruin.nl "Dave" wrote in message ... Can Excel convert a number ($12.00) in one cell and display it as text (Twelve and 00/100) in another? Similar to writing a check, proposal, etc... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| How to convert Numbers to text | Excel Worksheet Functions | |||
Hybrid Mode
