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.-