Datatext to columns, click next twice and under column data format select
date and MDY
click finish, that gave me

10/1/1995
9/22/2003
12/1/1998
6/30/2001


--

Regards,

Peo Sjoblom


"Michael" wrote in message
news:AY5Rd.46436$Vg3.32373@lakeread05...
Hi Folks - I have a column of dates such as:

100195
92203
120198
63001

The column has a number format. What is the easiest way to convert the
number 'dates' into real dates. I've tried the DATE function but some of
the
dates are converted to the 1900s.

Thanks in advance.

Michael