Currency Conversion Formula
 

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.

Currency Conversion Formula
 

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.

Currency Conversion Formula
 

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.