How to show full cell contents?
Hi Claus,
No, it is indeed empty.
I had been assuming that cell B2 would be treated identically to B1, as text. Both have a General format. And I also tried Text format in vain.
However, I now realise that Excel must be insisting on treating it as a date. So I'll simply prefix it with a single quote character.
Terry, East Grinstead, UK
|