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

[Dave]

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" <Dave@discussions.microsoft.com> wrote in message news:EA4716BA-B04C-41C4-BBC0-63A293897960@microsoft.com...
> 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" <Dave@discussions.microsoft.com> wrote in message news:EA4716BA-B04C-41C4-BBC0-63A293897960@microsoft.com...
> > 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...
>
>
>