How to convert Dollars & cents from numbers to words?

[Cedric Lee]

Hi,
Can anyone tell me if there is any function or formulae that can change
a dollar value, eg $2,400.00 in cell "A1" to display as "Two Thousand
Four Hundred Dollars Only" in cell "B1" ??
Your help is much appreciated. Thank you.

Rgds
Cedric

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Gord Dibben]

Cedric

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

http://support.microsoft.com/default.aspx?scid=kb;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

 

[Don Guillett]

An often asked question. Suggest the archives or using Ron De Bruin's google
search add in for
text to numbers
http://www.rondebruin.nl/