Problem is... as soon as you open the file, the date data is corrupted. Changing the cell format afterwards does not help.

eg. "01/02/2008" gets converted to 2/01/2008
and "20/02/2008" gets converted to 20/02/2008

Then changing the cell format to dd/mm/yyyy the values do not change.

Weird thing is... If I just double click on the csv file in Windows Explorer then the data is ok, but my autofilters and auto column width bits have to be done manually...
_________________________
Regards,
Andy.

--Just shoot me, please.--