Sorry, it becomes A1=10 and another cell eg. B1=10.
I want A1=10 and another cell eg. B1=ten

"Kassie" wrote:

With your number in A1, insert the following formula where you want the
conversion done. Right aligned "10" in A1 will become left aligned (text)
"10" in result cell

=IF(ISNUMBER(A1),TEXT(A1,0),A1)

--
Hth

Kassie Kasselman
Change xxx to hotmail


"wrashna ryvuh gurung" wrote:

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