View Single Post
  #6   Report Post  
Sandy Mann
 
Posts: n/a
Default

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