Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / September 2007



Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richy - 18 Sep 2007 20:04 GMT
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 - 18 Sep 2007 20:27 GMT
> 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 - 20 Sep 2007 19:09 GMT
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

On 9/18/07 3:04 PM, in article
5C5B4BDD-A68A-4FF0-A232-D3D1CAD7BEC4@microsoft.com, "Richy"

> Hi,
>
[quoted text clipped - 75 lines]
> 9/1/2011
> 8/3/2011
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.