Format dollar amounts for check printing

dford · Nov 20, 2005

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 · Nov 20, 2005

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 · Nov 20, 2005

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)