LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skoag
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I stop Excel Advancing the year by 1 when I enter a date? Priscilla Excel Discussion (Misc queries) 4 April 1st 06 02:55 PM
Automatically date cell in Excel BGS Excel Worksheet Functions 2 September 2nd 05 05:37 PM
how to enter the date automatically? Jahcureus Excel Discussion (Misc queries) 4 May 13th 05 09:10 PM
How do I stop excel automatically changing my date to 2005? zoemcb Excel Discussion (Misc queries) 6 April 30th 05 02:39 AM
Automatically enter date and time but only update once. PM New Users to Excel 3 January 21st 05 07:47 AM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"