a number is replaced by text when inserted anywhere in the sheet
 

I want to assign text to a numerical number. The text must be displayed when
the number is inserted into a cell.

a number is replaced by text when inserted anywhere in the sheet
 

Hi

Create a custom format (FormatCellCustom), like
# ##0\ "Text"


Arvi Laanemets


"Marga" wrote in message
...
I want to assign text to a numerical number. The text must be displayed
when
the number is inserted into a cell.