dollar figure to text function

[marion]

I'm trying to print pre-printed checks from excel. Is there a way I can
convert the dollar amount into text?

 

[JE McGimpsey]

Check out

http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)