day increasing by 1 when i drag and drop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dencara - 09 May 2008 22:30 GMT

when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you

Reply to this Message

Mike H - 09 May 2008 22:33 GMT

Hi,

With a date in A1 put this in a2
=A1
now drag A2 and the date wont change.

Mike

> when I drag and drop a date format the day value increases by one. how do I
> stop this? Thank you

Reply to this Message

JE McGimpsey - 09 May 2008 22:39 GMT

Are you sure it's not increasing by 1 day + 4 years?

That behavior happens when you copy from a workbook using the 1900 date
system and paste into a workbook using the 1904 date system.

If it's really only one day, I've no idea...

> when I drag and drop a date format the day value increases by one. how do I
> stop this? Thank you

Reply to this Message

Peo Sjoblom - 09 May 2008 22:55 GMT

What do you mean by drag and drop, if you mean you are dragging a date using
the mouse
and autofill? If you don't want it to increase by a day hold down ctrl while
copying.

Signature

Regards,

Peo Sjoblom

> when I drag and drop a date format the day value increases by one. how do
> I
> stop this? Thank you

Reply to this Message

Gord Dibben - 10 May 2008 19:09 GMT

Right-click and drag.

Release the button and "Copy cells"

Gord Dibben MS Excel MVP

>when I drag and drop a date format the day value increases by one. how do I
>stop this? Thank you

Reply to this Message