G Guest Sep 20, 2005 #1 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?
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?
A Anne Troy Sep 20, 2005 #2 Start-->Settings-->Control Panel, Regional Settings is using a different date system. ************ Anne Troy www.OfficeArticles.com
Start-->Settings-->Control Panel, Regional Settings is using a different date system. ************ Anne Troy www.OfficeArticles.com
G Gord Dibben Sep 20, 2005 #3 Check out the settings at Tools>Options>Calculation. 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
Check out the settings at Tools>Options>Calculation. 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
