Hey there,
There's likely a sleeker formula but heck try this:
=(LEFT(A2,LEN(A2)-6)&"/"&LEFT(RIGHT(A2,6),2)&"/"&RIGHT(A2,4))+0
You'll likely want to format the cell with a date format (otherwise you'll get the serial number behind the actual date).
Hope that helps out,
Adam