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