converting a number into text
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 ?
|