View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] terrypingm@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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