Can excel give value in words of number entered in another cell?
 

I entered the amount 125 in the cell A1. I want excel to convert the value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the amount.
Is there any formula for this? can any one help?

Try this: http://www.ozgrid.com/VBA/ValueToWords.htm
*******************
~Anne Troy

www.OfficeArticles.com


"nivedrajesh" wrote in message
...
I entered the amount 125 in the cell A1. I want excel to convert the
value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the
amount.
Is there any formula for this? can any one help?

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nivedrajesh" wrote in message
...
I entered the amount 125 in the cell A1. I want excel to convert the
value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the
amount.
Is there any formula for this? can any one help?

Can excel give value in words of number entered in another cell?
 

"nivedrajesh" wrote:

I entered the amount 125 in the cell A1. I want excel to convert the value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the amount.
Is there any formula for this? can any one help?

Can excel give value in words of number entered in another cell?
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"V.V.Subbarao" wrote in message
...


"nivedrajesh" wrote:

I entered the amount 125 in the cell A1. I want excel to convert the
value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell,
say
A2. The value in words should change automatically when I change the
amount.
Is there any formula for this? can any one help?