Date Function
 

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

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

Excellent! I would have nbever thought of using Text to Columns for this
......

Thanks!

"Peo Sjoblom" wrote in message
...
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