converting dates
 

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.

converting dates
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"JT" schrieb im Newsbeitrag
...
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.