Office 2004 for MAC OSX 10.4.10 EXCEL showing incorrect year 2011 HELP!

[Richard Schiff]

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

 

[JE McGimpsey]

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.

 

[Richy]

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

 

[JE McGimpsey]

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...

 

[Richy]

JE,

Sorry... for some reason multiple replys appearing. Please excuse.

Rich

 

[Chris Lee]

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 ?

 

[Bob Greenblatt]

On 9/26/07 9:16 PM, in article
(e-mail address removed), "Chris Lee" <Chris

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.

 

[Chris Lee]

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

 

[JE McGimpsey]

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)

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.

 

[Chris Lee]

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...

 

[JE McGimpsey]

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...

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.