Converting numbers to text
 

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

Converting numbers to text
 

Graeme Wrote:
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 Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=482234

Converting numbers to text
 

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

"Graeme" wrote in message
...
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

Converting numbers to text
 

Hi Graeme

See:

http://support.microsoft.com/default...EN-US;Q213360&
or
http://support.microsoft.com/default...N-US;q140704&;
--
Gary's Student


"Graeme" wrote:

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