When I try to edit a reference to a text cell, instead of seeing the value of the text cell, I see the literal text.
Example: A1 (value AAA) and B1 (BBB) are text cells (in format cells, number - category), C1 contains =A1, the value AAA is shown.
When I edit the reference, changing it to
B1, the value =B1 is shown instead of BBB.
Further investigation lead to this info:
When C1 is of general format, and I edit it,
the cell somehow looses its format but the value is shown all right. Next time I edit
the cell, the value is not shown anymore.
Is this a bug? A feature? What can I do about this annoying behaviour?
Thanks for your help,
René
Example: A1 (value AAA) and B1 (BBB) are text cells (in format cells, number - category), C1 contains =A1, the value AAA is shown.
When I edit the reference, changing it to
B1, the value =B1 is shown instead of BBB.
Further investigation lead to this info:
When C1 is of general format, and I edit it,
the cell somehow looses its format but the value is shown all right. Next time I edit
the cell, the value is not shown anymore.
Is this a bug? A feature? What can I do about this annoying behaviour?
Thanks for your help,
René