Thank you...it worked! I did have years in the 1800s, but I just added the
equivalent of 100 yrs to them to make them 1900s.

dan

"Rick Rothstein (MVP - VB)" wrote:

Do you really have dates before 1900 as your example showed? If so, I don't
think Excel will be able to handle them. If on other hand, that was just a
mistaken year example, then try this procedure... select your column of
numbers, click Date/TextToColumns on Excel's menu bar, click OK twice to get
to Step 3 of 3 and select YMD from the Date drop-down in the upper right
corner of the dialog box, then click Finish. That should turn your numbers
into real dates.

Rick


"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.