This seemed to work well, until i went into the sheet, and it it
changing dates around as it is seeing them as US dates.
The cell should take up the format of the copied cell when the Paste Special
is activated, at least it does with me. Make sure that the cell that you
are copying is formatted the way that you want it to be.
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk