Currency Conversion Formula

P

pantherguy

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

Niek Otten

Not entirely what you describe, but do check

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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