=LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,4) will do the sample date you have
given,
but we need a little more info to be able to help more.........do you have
many "dates" like this to do?.........do the single digit months have
leading zeros? are there double digit months in your data of
interest?..........are the days always two digits?

Vaya con Dios,
Chuck, CABGx3

"George" wrote in message
...
I want to format date cells from 6302000 to 6/30/2000. Could you please
help
with this?