HELP!!! Office 2004 for MAC BUG: EXCEL Changing dates!

[Richy]

Hi,

I am running OFFICE 2004 for MAC on an Intel MacPro running OSX 10.4.10.

I just noticed that when I view files created on my MAC on a PC running
Office 2003 Pro the files have that wrong dates. The year is reading 2011
and sometimes the month and day are changes as well.

Files appeared OK on the MAC....

Is this a known bug? What can I do? See below:

PROJECT DATE
Custom Curriculum Mgmt Phase II 7/4/2011
INFORM 7.0 7/10/2011
Custom Curriculum Mgmt Phase II 7/10/2011
7/10/2011
INFORM 7.0 7/10/2011
INFORM 7.0 7/11/2011
Custom Curriculum Mgmt Phase II 7/11/2011
INFORM 7.0 7/11/2011
Custom Curriculum Mgmt Phase II 7/12/2011
Custom Curriculum Mgmt Phase II 7/14/2011
8/18/2011
8/30/2011
8/31/2011
Custom Curriculum Mgmt Phase II 8/14/2011
Custom Curriculum Mgmt Phase II 8/15/2011
Custom Curriculum Mgmt Phase II 8/16/2011
Custom Curriculum Mgmt Phase II 8/17/2011
Custom Curriculum Mgmt Phase II 8/24/2011
Custom Curriculum Mgmt Phase II 8/30/2011
Curriculum Management Phase 2.1 8/7/2011
Curriculum Management Phase 2.1 8/8/2011
Curriculum Management Phase 2.1 8/9/2011
Curriculum Management Phase 2.1 8/10/2011
Curriculum Management Phase 2.1 8/15/2011
Curriculum Management Phase 2.1 8/16/2011
Curriculum Management Phase 2.1 8/17/2011
Curriculum Management Phase 2.1 8/18/2011
Curriculum Management Phase 2.1 8/24/2011
Custom Curriculum Mgmt Phase II 8/2/2011
EC - SUCCESS 8/18/2011
EC - SUCCESS 9/1/2011
8/2/2011
8/4/2011
8/4/2011
IDC - UI Enhancements 8/23/2011
8/1/2011
8/22/2011
8/23/2011
8/24/2011
9/1/2011
8/1/2011
8/2/2011
8/3/2011
IDC - UI Enhancements 8/23/2011
8/28/2011
8/30/2011
8/31/2011
8/17/2011
8/29/2011
8/30/2011
8/31/2011
INFORM 7.0 8/31/2011
INFORM 7.0 8/1/2011
INFORM 7.0 8/2/2011
INFORM 7.0 8/4/2011
INFORM 7.0 8/8/2011
INFORM 7.0 8/9/2011
INFORM 7.0 8/15/2011
INFORM 7.0 8/17/2011
INFORM 7.0 8/21/2011
INFORM 7.0 8/23/2011
INFORM 7.0 8/24/2011
INFORM 7.0 9/1/2011
TCS Improvements 8/4/2011
9/1/2011
8/3/2011

 

[JE McGimpsey]

I just noticed that when I view files created on my MAC on a PC running
Office 2003 Pro the files have that wrong dates. The year is reading 2011
and sometimes the month and day are changes as well.

See your other thread where you've already received an answer.

Please don't post new messages that deal with the same problem - it just
tends to fragment any answers you get, and potentially waste the time of
those answering a problem that has already been answered.

 

[Patrick Mulvey]

Hi Richy,
I also had this problem. Here is how I solved it.
Go to Menu Bar: Excel / Preferences
Click on the third option for "Calculation"

Notice that in the lower right-hand area :Workbook Options
Uncheck the: 1904 date system

That may solve it.
Good Luck.

Patrick