HOW TO TRANSLATE FIGURES TO AMOUNT IN WORDS

[TUNJI]

IN MICROSOFT EXCEL, IS THERE ANY FORMULA BY WHICH THE 'FIGURE' THAT APPEAR IN
A CELL CAN BE TRANSLATED TO 'WORDS' IN ANOTHER CELL? E.G. IF CELL A3 CONTAINS
195, CAN WE MAKE CELL A5 TO READ 'ONE HUNDRED AND NINETY FIVE'?

 

[Gary''s Student]

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&

 

[Bob Phillips]

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)