Thread: In Excel why does the date I enter automatically change by 1 day?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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 With QuoteReply With Quote