Hi David,

Thanks for that but, I have no control over the exported file format as it's
all hard coded in the 3rd party app. I can only control the Excel environment.

I need a resolution based on the receiving app (Excel2007) only, if possible?

In the mean time I have logged it with the 3rd party programmers to alert
them as this WILL be a problem for all users of their software.

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


"David Biddulph" wrote:

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