Change number to word

[Khai]

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

 

[Niek Otten]

Look here for several solutions:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Mike H]

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

 

[Teethless mama]

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","")

 

[N.D.PERERA]

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