Format dollar amounts for check printing

[Guest]

I would like to format a number to print amount on a check. For example:
$5,280.25 Format to: Five thousand two hundred eighty and 25/100 dollars

 

[Norman Jones]

Hi D,

See:

How to convert a numeric value into English words in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360


How To Convert Currency or Numbers into English Words
http://support.microsoft.com/?scid=kb;en-us;259663

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)