 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2008Office 2004 for MAC OSX 10.4.10 EXCEL showing incorrect year 2011 HELP!
I just noticed that my Office 2004 for MAC running on an Intel MacPro OSX 10. 4.10 is showing bogus dates note the year 2011. Is this a known bug... and is there a fix?: 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 > I just noticed that my Office 2004 for MAC running on an Intel MacPro OSX 10. > 4.10 is showing bogus dates note the year 2011. Is this a known bug... and > is there a fix?: It's not a bug - XL has two date systems - the Mac default 1904 system and the Windows default 1900 system. You're using a worksheet built with the 1900 system in the 1904 system (XL chooses the system of the first workbook opened in each session - including the Personal Macro Workbook, if you have one). To return the dates to 2007, choose Preferences/Calculation. Uncheck the 1904 Date system checkbox. Dear JE, Can this be done on the PC ( Office 2003 Pro) on which the EXCEL files are on now? Where exactly is this setting located? Must this be done on the MAC ( Office 2004) on which the files were created? Thanks, Rich > > I just noticed that my Office 2004 for MAC running on an Intel MacPro OSX 10. > > 4.10 is showing bogus dates note the year 2011. Is this a known bug... and [quoted text clipped - 8 lines] > To return the dates to 2007, choose Preferences/Calculation. Uncheck the > 1904 Date system checkbox. > Can this be done on the PC ( Office 2003 Pro) on which the EXCEL files are > on now? Where exactly is this setting located? Must this be done on the MAC > ( Office 2004) on which the files were created? It can be done in either. On the WinXL side, it's Tools/Options/Calculation... JE, Sorry... for some reason multiple replys appearing. Please excuse. Rich > > Can this be done on the PC ( Office 2003 Pro) on which the EXCEL files are > > on now? Where exactly is this setting located? Must this be done on the MAC > > ( Office 2004) on which the files were created? > > It can be done in either. On the WinXL side, it's > Tools/Options/Calculation... excellent this seems to work great on a per file basis, but every single file I get from a windows computer my mac opens it up and the 1904 button is checked, and every single file I have to uncheck it to get the dates to work. is there a way to make this setting permanent ? On 9/26/07 9:16 PM, in article 67D8702F-4583-45B3-9F38-1560B48D417E@microsoft.com, "Chris Lee" <Chris Lee@discussions.microsoft.com> wrote: > excellent this seems to work great on a per file basis, but every single file > I get from a windows computer my mac opens it up and the 1904 button is > checked, and every single file I have to uncheck it to get the dates to work. > > is there a way to make this setting permanent ? This setting is set by the FIRST file to be opened by excel. If you start Excel and then open the file from windows, the 1904 date will probably be in effect from the "workbook template." You can change the date format in the default workbook template. Search Help for "template" for instructions.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom This may be how its supposed to work, but its not. dates are fine in windows, open the file in osx and their wrong. if I open each file and uncheck 1904 then my dates are right. now when you get 10 excel files a day, this is really anoying to have todo this to each and every file. so either windows is not setting the date paramater (I bet it is setting it) or osx is not reading that setting from the file (most likley the case) Chris Lee > On 9/26/07 9:16 PM, in article > 67D8702F-4583-45B3-9F38-1560B48D417E@microsoft.com, "Chris Lee" <Chris [quoted text clipped - 9 lines] > effect from the "workbook template." You can change the date format in the > default workbook template. Search Help for "template" for instructions. > This may be how its supposed to work, but its not. > [quoted text clipped - 6 lines] > so either windows is not setting the date paramater (I bet it is setting it) > or osx is not reading that setting from the file (most likley the case) Read what Bob wrote again - the setting is determined by the FIRST workbook opened. If you have a workbook template file in your Startup folder (by default: HD:Applications:Microsoft Office 2004:Office:Startup:Excel but you may set an Alternate Startup File in Preferences/General) then that will set the date system. If you have a Personal Macro Workbook set, THAT will set the date system. Once XL starts, the date system will stay the same. ok so Ive got the template working, when I create a new file it uses the 1900 date system. but when opening files that came from a windows computer, I still have to uncheck 1904. how does this macro work ? Ive never used macro's before. I was hoping ms would have fixed this issue in 2008, but it apears they havent... :( > > This may be how its supposed to work, but its not. > > [quoted text clipped - 19 lines] > > Once XL starts, the date system will stay the same. > ok so Ive got the template working, when I create a new file it uses the 1900 > date system. but when opening files that came from a windows computer, I [quoted text clipped - 4 lines] > I was hoping ms would have fixed this issue in 2008, but it apears they > havent... :( Well, there really isn't anything to fix - both date systems are valid, and you can have workbooks using both systems open at the same time. And since dates are just numbers to XL, and users can rely on doing math with those numbers, there's no way of automatically converting between systems without breaking user models. Don't worry about macros - they don't work in XL08. You shouldn't have to uncheck the 1904 checkbox when opening files from a Windows computer, unless they're using the 1904 system too (or they've used a workbook that originated on a Mac). Bottom lines with dates is you need to be careful when you copy from one workbook to another. Otherwise they're usually not an issue. |
Reply to this Message |
 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
|
©2008 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.