D
dencara
when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you
stop this? Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
With a date in A1 put this in a2
=A1
now drag A2 and the date wont change.
Mike
With a date in A1 put this in a2
=A1
now drag A2 and the date wont change.
Mike
J
JE McGimpsey
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...
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...
P
Peo Sjoblom
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.
--
Regards,
Peo Sjoblom
the mouse
and autofill? If you don't want it to increase by a day hold down ctrl while
copying.
--
Regards,
Peo Sjoblom
G
Gord Dibben
Right-click and drag.
Release the button and "Copy cells"
Gord Dibben MS Excel MVP
Release the button and "Copy cells"
Gord Dibben MS Excel MVP