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

Dave · May 13, 2005

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 · May 13, 2005

Dave · May 14, 2005

Thanks Ron

Worked perfectly!

Ron de Bruin said:
Hi Dave

See
http://www.xldynamic.com/source/xld.xlFAQ0004.html