i need a macro that can convert a dollar amount to a line
of text. like $4,926.50. would equal Four Thousand Nine
Hundred Twenty-Six and 50/100 Dollars. TIA.

franz

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 he

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

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

Gord Dibben Excel MVP

On Fri, 30 Jan 2004 16:50:43 -0800, "franz"
wrote:

i need a macro that can convert a dollar amount to a line
of text. like $4,926.50. would equal Four Thousand Nine
Hundred Twenty-Six and 50/100 Dollars. TIA.