#1   Report Post  
Old September 20th 05, 03:09 PM
DA
 
Posts: n/a
Default Date Changes

I have a share file that shoes the dates in the year 2005. When I copy the
file, the dates change to 2001. What is causing the change?

  #2   Report Post  
Old September 20th 05, 03:50 PM
Anne Troy
 
Posts: n/a
Default

Start--Settings--Control Panel, Regional Settings is using a different
date system.
************
Anne Troy
www.OfficeArticles.com

"DA" wrote in message
...
I have a share file that shoes the dates in the year 2005. When I copy the
file, the dates change to 2001. What is causing the change?



  #3   Report Post  
Old September 20th 05, 05:21 PM
Gord Dibben
 
Posts: n/a
Default

Check out the settings at ToolsOptionsCalculation.

It sounds like you have "1904 date system" checked.

Uncheck it.

More on dates at Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 07:09:04 -0700, "DA" wrote:

I have a share file that shoes the dates in the year 2005. When I copy the
file, the dates change to 2001. What is causing the change?




Reply
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 do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Recurring annual events using a specific date as a trigger date Bamboozled Excel Worksheet Functions 1 June 6th 05 01:44 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 12:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017