ExcelBanter - Date Changes

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Date Changes (https://www.excelbanter.com/setting-up-configuration-excel/46313-date-changes.html)

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?

Anne Troy

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?

Gord Dibben

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?

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