Hi Jim

Try
=MID(A1,5,2)&"/"&LEFT(A1,4)&"/"&RIGHT(A1,2)

Regards

Roger Govier


JIM.H. wrote:
Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,