how to write a number in words in excel worksheet?
 

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

how to write a number in words in excel worksheet?
 

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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

how to write a number in words in excel worksheet?
 

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