Look here for several solutions:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khai" wrote in message ...
| Hi
| Im preparing Voucher in spreedsheet, i want to change the number to word
| format automatically.
|
| eg.
|
| cell A1 = 2,000.10
|
| cell c1 = Two Thousand and Ten Cents Only
|
| can any body help me