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.
|