Editing Reference to Text Cell

[Rene]

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é

 

[Chris Davison]

Rene,

I had this the other night



I popped the formulae onto a new sheet, saved and rebooted....

not much help, huh ?!

Chris