Hi Terry,

Am Sun, 22 Jan 2017 15:57:37 +0000 schrieb Terry Pinnell:

I raised this early in December and I thought I'd sort of answered it
myself... But on returning to it today I still don't really understand
why cell b6 get doesn't get fully displayed as 'Saturday 21 January
2017', stretching into column C, like the cells above? (C6 is empty, of
course.)

thats the behaviour of a numbers and dates. Only text will extend to the
cell of the right if this cell is empty.
If columns are too small numbers are shown in scientific format and
dates as number signs.
You have to enlarge the columns width or create a text formatted date if
you don't have to calcualte with.


Regards
Claus B.
--
Windows10
Office 2016