When copying & pasting dates in a few of my worksheets, they change to one
day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.

Can anyone tell me what I am doing wrong?

Thank you,

Copy > Paste Special > Values > OK

"CAMiller" wrote:

> When copying & pasting dates in a few of my worksheets, they change to one
> day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
>
> Can anyone tell me what I am doing wrong?
>
> Thank you,

Some of your Workbooks are set up to use the 1904 date system, others are
not, so they default to the 1901 date system.

You'll find the setting under Tools->Options. Not sure which tab for Excel
versions prior to 2007 (I've been upgraded to Excel 2007 - there it is under
Excel Options on the Advanced tab)


"CAMiller" wrote:

> When copying & pasting dates in a few of my worksheets, they change to one
> day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
>
> Can anyone tell me what I am doing wrong?
>
> Thank you,

It's under tools>options>calculation in pre 2007 versions


--
Regards,

Peo Sjoblom



"Duke Carey" <(E-Mail Removed)> wrote in message
news:5C509EB7-1971-408A-8CE0-(E-Mail Removed)...
> Some of your Workbooks are set up to use the 1904 date system, others are
> not, so they default to the 1901 date system.
>
> You'll find the setting under Tools->Options. Not sure which tab for
> Excel
> versions prior to 2007 (I've been upgraded to Excel 2007 - there it is
> under
> Excel Options on the Advanced tab)
>
>
> "CAMiller" wrote:
>
>> When copying & pasting dates in a few of my worksheets, they change to
>> one
>> day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
>>
>> Can anyone tell me what I am doing wrong?
>>
>> Thank you,

It sounds like the source is set to use the 1904 date system.

Goto Tools>Options>Calculation tab>1904 date system

Uncheck that setting. Be careful though, this will change all the dates
already entered. This will add 4 years to your existing dates.

--
Biff
Microsoft Excel MVP


"CAMiller" <(E-Mail Removed)> wrote in message
news:61126FE9-C3BF-4FE3-949B-(E-Mail Removed)...
> When copying & pasting dates in a few of my worksheets, they change to one
> day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
>
> Can anyone tell me what I am doing wrong?
>
> Thank you,

Hallelujah! Thanks for tip. Saved me hours!!!

"T. Valko" wrote:

> It sounds like the source is set to use the 1904 date system.
>
> Goto Tools>Options>Calculation tab>1904 date system
>
> Uncheck that setting. Be careful though, this will change all the dates
> already entered. This will add 4 years to your existing dates.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "CAMiller" <(E-Mail Removed)> wrote in message
> news:61126FE9-C3BF-4FE3-949B-(E-Mail Removed)...
> > When copying & pasting dates in a few of my worksheets, they change to one
> > day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
> >
> > Can anyone tell me what I am doing wrong?
> >
> > Thank you,
>
>
>