converting dates

[JT]

I have a macro that is used by both the international and
domestic operations.

I could use some help with the code to convertthe European
dates 170604 to 06/17/04.

The cells are formatted as general, so I don't get the
correct date if I try just formatting the cells.

Thanks for the help.

 

[Frank Kabel]

Hi
try the following formula
=DATE("20" & RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))