Converting numbers to text

[Graeme]

Can anyone help?

I want to be able to a macro / function that reads a cell and converts the
number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven

Sounds straight forward but I'm coming unstuck.

Thanks

 

[Paul Sheppard]

Can anyone help?

I want to be able to a macro / function that reads a cell and converts
the
number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven

Sounds straight forward but I'm coming unstuck.

Thanks

Hi Graeme

Have a look at this thread

http://www.excelforum.com/showthread.php?t=478470

 

[Paul B]

Graeme, have a look here,

http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gary''s Student]

Hi Graeme

See:

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