=IF(LEN(D12)=6,LEFT(D12,2)&"/"&MID(D12,3,2)&"/"&RIGHT(D12,2),"0"&LEFT(D12,1)&"/"&MID(D12,2,2)&"/"&RIGHT(D12,2))

Assuming that your data is in D12.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"theresa317" escreveu:

I received a worksheet from someone with the date stated as a number. ie..
100364, 80763. These are actual dates without any formatting(/ -). I need a
formula that will insert a "/". Thanks