This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"A J" <A wrote in message
...
How Can I Change the Numbers to Words in Excel.
Eg I want to chnge 9001 to "Nine Thousand and One Only"