Why does Excel Copy and Paste change dates from the original when.
 

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

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?

Me on a Friday night?

(Sometimes, you make it too easy!)



Gord Dibben wrote:

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?

--

Dave Peterson

Oh, I don't think Friday has anything to do with it. <g

Dave Peterson wrote:
Me on a Friday night?

(Sometimes, you make it too easy!)



Gord Dibben wrote:

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?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you for your continued support.

Debra Dalgleish wrote:

Oh, I don't think Friday has anything to do with it. <g

Dave Peterson wrote:
Me on a Friday night?

(Sometimes, you make it too easy!)



Gord Dibben wrote:

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?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

LOL

Gord

On Tue, 25 Jan 2005 19:51:25 -0600, Dave Peterson
wrote:

Me on a Friday night?

(Sometimes, you make it too easy!)



Gord Dibben wrote:

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?