how to write a number in words in excel worksheet?

[minithao]

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

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[Shah Shailesh]

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