You may have serious problems, a volatile mixture of correct dates, wrong
dates and text that look like dates but has no date value. So when you say
that "most dates remain the same" -try changing date format for the cell and
see if it even can be done. If not then it's not a date, it's just text.

The idea would be to ensure that this doesn't happen. You don't provide any
detail on the export routine, but the problem is there.

HTH. best wishes Harald

"Nick B" skrev i melding
...
When exporting large amounts of information into Excel (Office 2000) some
of
the date formats are changed but not all.Most are kept as DDMMYY but some
are
turned around like US format into MMDDYY.Before exporting it will read
11/4/05 but after exporting into excel becomes 4/11/05.As i say 80% of
dates
remain the same as from Citrix program they been exported from.Any ideas
anyone?