Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/
then use this formula

=NBTEXT(A1)&IF(MOD(A1,1)," Cents","")


"Khai" wrote:

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