=Date(int(a1/10000),mod(int(a1/100),100),mod(a1,100))

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Sandyw" wrote in message
...
I have a date entered as 20050103. How do I get it to change to 1/3/05?