can excel convert number into words (like 10 to ten)?
 

can excel convert number stored in one column to words to be copies to
another cell?
suppose I put the number 10 in cell a1, is there any way that excel
automatically give the value TEN in another cell? it should keep on changing
when I change the number.

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

--
HTH

Bob Phillips

"nivedrajesh" wrote in message
...
can excel convert number stored in one column to words to be copies to
another cell?
suppose I put the number 10 in cell a1, is there any way that excel
automatically give the value TEN in another cell? it should keep on
changing
when I change the number.

There is a free ADDIN available which will provide a function to do this.
Go to the link below
http://longre.free.fr/english/



--
Regards
Roger Govier
"nivedrajesh" wrote in message
...
can excel convert number stored in one column to words to be copies to
another cell?
suppose I put the number 10 in cell a1, is there any way that excel
automatically give the value TEN in another cell? it should keep on
changing
when I change the number.