If by TEXT, you mean WORDS, then this old response from Ron may help.

Check these websites:
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://support.microsoft.com/default...;EN-US;Q213360
I hope that helps.
Regards,
Ron


Vaya con Dios,
Chuck, CABGx3


--
Ron Coderre


"padhma gurung" wrote:

show with example how to change a number of 1 cell into a text form in the
another cell ?