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