If you use the wizard to open/import the text file, on the last screen you
can go field by field selecting basic formating options. You can select you
date fields, and mark if you want them imported as MDY or DMY.

Hope this helps,
Miguel.

"rmcsantos" wrote:

i have 2 files, one create a txt file, and export a cell value with a date.
6-12-2006
The second file import txt file, and read the date field, and change
12-6-2006.

How can resolve this question?

Thank you in advance.
--
Rui Santos