Hi

With date in A1
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
and format in any valid date format


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


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