6 digit code to date

[wawa]

I have many dates in a column in a 6 digit format such as:

950223
950224
950225
These dates are Feb 23, 1995; Feb 24, 1995 etc.

How can I convert these dates in the column to 2/23/1995, 2/24/1995 etc?

Thanks in advance for any help.

[ncmay]

If your numbers start in A1, try the following formula in cell B1 and copy it down.

Please Login or Register  to view this content.

Then Date format B1.

[shg]

Or =(19 + (A1<300000) & TEXT(A1, "00-00-00") )+0

[wawa]

Wow:

That was fast; and it worked!!

Thanks very much