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


"mr_bsh" wrote in message
...
I would like to take a number field in one cell and in another cell have
the
it in words. For example in cell A1 = 1550 while in cell A2 it says ONE
THOUSAND FIVE HUNDRED AND FIFTY

Is there any way to do this???? Plz Help. Thanks in advance.