Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day increasing by 1 when i drag and drop
when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day increasing by 1 when i drag and drop
Hi,
With a date in A1 put this in a2 =A1 now drag A2 and the date wont change. Mike "dencara" wrote: when I drag and drop a date format the day value increases by one. how do I stop this? Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day increasing by 1 when i drag and drop
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... In article , dencara wrote: when I drag and drop a date format the day value increases by one. how do I stop this? Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day increasing by 1 when i drag and drop
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 "dencara" wrote in message ... when I drag and drop a date format the day value increases by one. how do I stop this? Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day increasing by 1 when i drag and drop
Right-click and drag.
Release the button and "Copy cells" Gord Dibben MS Excel MVP On Fri, 9 May 2008 14:30:00 -0700, dencara wrote: when I drag and drop a date format the day value increases by one. how do I stop this? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drag and drop | Excel Discussion (Misc queries) | |||
Increasing number of unique entries in the drop-down list | Excel Discussion (Misc queries) | |||
Increasing distance labels using drag down method | Excel Worksheet Functions | |||
Drag and drop | New Users to Excel | |||
Increasing the size of text in a Drop Down box | Excel Discussion (Misc queries) |