I tried it but look here is what I obtained:

A1: 12/20/2004

Applied the formula and obtained: 07/06/2004

Don't get it...

"Frank Kabel" wrote:

Hi
try the following formula in a helper column
=DATE("20"&RIGHT(A1,2),MID(A1,4,2),LEFT(A1,2))
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

Emece wrote:
Thks Frank, but the dates are stored as text.

"Frank Kabel" wrote:

Hi
if the dates are stored as real Excel dates you only have to change
the format ('format - Cells')

--
Regards
Frank Kabel
Frankfurt, Germany

Emece wrote:
I have the following problem in Excel XP:

I need to automatically convert dates in this format: dd/mm/yy to
mm/dd/yy. Is there a function to do this?

This is because I import dates from Visual Basic thta come in the
format mm/dd/yy and as my Excel XP is in Spanish I have dd/mm/yy.

Thks in advance!

Regards.
Emece.-