How do I convert number 123 to text One Hundred and Twenty Three?

Vidyaji · Sep 6, 2005

I am looking at some ready made functions to get number names. E.g. 123 as
text One Hundred and Twenty Three. Is there any such function available in
Excel?

Paul B · Sep 6, 2005

Vidyaji, 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