Can you explain how to convert the currency value
referenced in a specific cell to a written our version
used in contracts and on checks?

Example: $100.00 would be represented as "One Hundred
and 00/100".

Thank you.

Jeff

No built-in Function, but you can build your own User Defined Function using
the info at:

http://support.microsoft.com/default...;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from here:

http://longre.free.fr/english/index.html

Has a Numbers to Words Function along with many other useful Functions.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Tue, 5 Aug 2003 07:40:08 -0700, "Jeff" <(E-Mail Removed)> wrote:

>Can you explain how to convert the currency value
>referenced in a specific cell to a written our version
>used in contracts and on checks?
>
>Example: $100.00 would be represented as "One Hundred
>and 00/100".
>
>Thank you.