how do I convert numeric data to words?

[Guest]

I am trying to to convert numeric data to words. Example: 5.5 to five and
one half.
I recall reading somewhere that this can be done with a macro of some type,
unfortunatly I don't recal where I read this.

 

[Guest]

How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&;

 

[mudraker]

have a look at

http://www.excelforum.com/showthread.php?t=489756
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

 

[Guest]

That was exactly what I was looking for. Thank you.

I had to tweak it a little for my purpose since I wasn't daling with money.
But, it was only a few minor changes.