Date Function

M

Michael

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
 
P

Peo Sjoblom

Data>text 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
 
M

Michael

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

Thanks!
 
Top