Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel why does the date I enter automatically change by 1 day?
When I drag a date to the line below, it automatically adds 1 day to the
date. Also when I drag ticcker symbol NOV, it changes it to DEC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel why does the date I enter automatically change by 1 day?
In both cases, to prevent the autofill...
Hold down the [Ctrl] key when you drag the fill handle of the source cell. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "skoag" wrote: When I drag a date to the line below, it automatically adds 1 day to the date. Also when I drag ticcker symbol NOV, it changes it to DEC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I stop Excel Advancing the year by 1 when I enter a date? | Excel Discussion (Misc queries) | |||
Automatically date cell in Excel | Excel Worksheet Functions | |||
how to enter the date automatically? | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel |