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.