|Thanks for the reply !|
I have checked the date format as suggested but this is in English(UK) as perviously set ! DD/MM/YYYY.
The original .csv file is compiled by a number of .txt files taken from our assembly machines (PLDD/MM/YYYY.txt) on a daily basis, these are read by a batch file ( Copy PL*.txt > PLMaser.csv) and sent to the PLMaser.csv.
When reading the PLMaser in Excel it is ok, But when copy and pasted to the spreadsheet by the Macro the DD and MM are reversed ??
Also when trying to Format the DD/MM/YYYY in the original .csv before copy & paste, this also gets corrupted !
This does seem to be the default Regional and Language Options as you suggest but checking the setting it looks ok ?
Head scratcher !!! Pp