ozgrid.com wrote:
=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),"m m-dd-yyyy")

and copy paste special-values.

Hi,

[quoted text clipped - 10 lines]
Best Regards,
Terry

Thanks ozgrid.com
I tried and it works,
Thanks a lot.