In case you need to convert number to words with formula (No VBA Codes), you
can download "spellnoformula" (scroll to 4) from below webpage. You can have
5 options to select.


http://in.geocities.com/shahshaileshs/misc.htm


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins



"minithao" wrote in message
...


Could any one show me how to write a number in words. Which formular can
be
used?

Ex: In A1 : 565
A2 : =(????,A1) = five hundred and sixty-five