Copy and paste from where to where?

Perhaps the "dates" you are copying are Text and not real dates.

Give an example of a "strange date".


Gord Dibben Excel MVP

On Tue, 25 Jan 2005 13:27:04 -0800, "Excel changes dates in copy and paste"
<Excel changes dates in copy and wrote:

When copying and pasting dates, Excel pastes strange dates. Where do these
come from and how do I stop this from occurring?