Setting default date system to 1900 versus 1904

[Bugs]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I work in a large corporation that uses excel 100 times a day. My issue is that most of the files we work with are created on Win platform which defaults to the 1900 date system. When I create on the Mac, it defaults to the 1904 date system.

I realize I can change the date format in preferences on an individual basis but is there anyway to set the default to 1900 versus me having to remember to go to preferences every time on each individual sheet?

Thx

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I work in a large corporation that uses excel 100 times a day. My issue is
that most of the files we work with are created on Win platform which defaults
to the 1900 date system. When I create on the Mac, it defaults to the 1904
date system.

I realize I can change the date format in preferences on an individual basis
but is there anyway to set the default to 1900 versus me having to remember to
go to preferences every time on each individual sheet?

Thx

Make a workbook template with the date system set to 1900.