Excel date format will not recognise dates before 1900. I would suggest
that you use Data/ Text to Columns or another method to produce separate
columns for year month and day, and manipulate them separately.
--
David Biddulph

"dan" wrote in message
...
I have a column of imported data information of the format yyyymmdd, e.g.,
18400314. Excel does not recognize this date format. How do I change it so
that Excel will recognize it?
Many thanks for any help.