Hi,

There are a few sites with code to do this, this is as good as any.

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"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