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 [email protected]> 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 [email protected]> 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 [email protected]> 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 [email protected]> 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 <[email protected]>
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 [email protected]> wrote:
>>
>> >When copying and pasting dates, Excel pastes strange dates. Where do these
>> >come from and how do I stop this from occurring?