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


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"pantherguy" wrote in message
...
Does anyone know where I can find a formula to change a number into text,
kind of like writing a check? For example, if I type 10.71 into a field, I
would like it to display, Ten and 71/100 in another field. Any
suggestions.
Excel 2003.