Change number to word
 

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

Change number to word
 

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

Change number to word
 

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

Change number to word
 

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

Change number to word
 

"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