Pasting date values

OK - so you know how to copy stuff from one sheet to another and probably know how to do the Paste Special > Values thing to get the actual cell values rather than the cell reference.

But, when you do that the formatting can go dodgy, dates in particular.

So, rather than pasting the values go Paste Special > Values and number formats instead. And it works.

Rock and roll.