Is there anything other than dates in this column? For example, if you change the number format to, say, General, do all the dates change to 5-digit numbers? Is there anything else in the same column that isn't a date? For example, and ordinary number or some text?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,
As far as I can see, the only thing in the column are dates and some blank cells.

Cheers,

Andy