It may be worth checking your Windows Regional Options if it is drawing a
line at 12, to see whether it is getting confused between mm/dd/yyyy and
dd/mm/yyyy.
It may be cleaner to import all the data forcing it to text, rather than
date, then do Data/Text to Columns, and at the final stage specify YMD or
whatever as the format of the data being imported.
--
David Biddulph

"CopperHead" wrote in message
...
Hi,

I have a problem that involves date values of exported reports from a 3rd
party application that autogenerates the spreadsheet, whereby, ANY date
over
12 (regional date format = *14/03/2001) eg; 13/07/2007, is imported as a
text string 20070713 and refuses to reformat once the import is complete.

I've checked all Office option settings without result and am heading
towards it being something to do with DDE in the translation?

Can anyone shed some light on a solution please?

--
Keep the light on... and burn bright, not out...
CopperHead ;-D