Not entirely what you describe, but do check

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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.