Dates Windows to Mac

[MichaelQ]

I have recently moved from Window to Mac and discovered that some of the
dates in my worksheets are experiencing the effects of the 1900 and 1904 date
differences. I have hundreds of these worksheets and some have up to ten
thousands dates. So whatever changes I make must be accurate because I will
not be able to check them all.
I cannot work out how to change the options to correct the problem.

Help would be greatly appreciated.

 

[Mungo]

changes made are workbook specific. Open (and Save) a test workbook, then goto Excel>Preferences>Calculation icon and you will see a check box for the date system. Play around with this. If your dates are formulas, then you only have to change the top one. Perhaps one of MVP's know of another way!

 

[CyberTaz]

There should be no need to change anything. The Date System used is
workbook-specific regardless of which version of Excel created the file. The
displayed dates will be correct when you open that file in any other version
of Excel... This is *not* a Mac/PC compatibility issue -- a workbook can be
set to use either date system at the discretion of the user no matter which
operating system or Excel version they're using at the time.

The only circumstances where different date systems become a problem are:

If you *copy* dates from a workbook & paste to another workbook that's set
for the other date system, or

If you *Link* between workbooks which use different date systems.

For more on the subject & suggestions on how to deal with it see:

http://support.microsoft.com/kb/180162

HTH |:>)
Bob Jones
[MVP] Office:Mac