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