| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
