ExcelBanter - Convert $12.00 to text (Twelve dollars) like you would on a chec..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert $12.00 to text (Twelve dollars) like you would on a chec.. (https://www.excelbanter.com/excel-worksheet-functions/26135-convert-%2412-00-text-twelve-dollars-like-you-would-chec.html)

Dave

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...

Ron de Bruin

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...

Dave

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...

All times are GMT +1. The time now is 12:44 AM.