If the data is in a text file, I'd make sure the name of the file had an
extension of .txt.

Then just File|Open that Text file.

The data import wizard will appear and you'll be able to specify that this field
is a date in mdy order.
Then after the import, just change the number format to dd/mm/yyyy.



Neo wrote:

Is it possible to import data containing American style dates, eg. 10/15/06,
and convert them to European style dates eg. 15/10/06??

--

Dave Peterson