=DATE(2000+VALUE(MID(A1,2,2)),VALUE(MID(A1,4,2)),V ALUE(LEFT(A1,1))+VALUE(RIGHT(A1,2)))
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Dvelasq" wrote:

I have a date format that I can not convert to calandar dates;

the dates in column a

1060417

anybody know what I should use to convert to
04/18/06