our internal software based on Zend throws Date Exception Errors for Excel Files from Mac Users. Same File stored on Windows passes.

So someone told me that in both OpenOffice and Excel for Mac (some here use the 2011 version) you can switch to "Windows Date Format" somehow but i can not find anything about this on google nor can i find it in the settings.

Any idea?

1 Answer 1


The instructions for switching to Windows date format on Excel for Mac can be found here.

So the steps are:

  1. On the Excel menu, click Preferences.
  2. Under Formulas and Lists, click Calculation.
  3. Under Workbook options, select the Use the 1904 date system check box.
  • No, that's a different problem. That would just result in "wrong calculation" but what i talk about is a completely different format that can not be parsed. Oct 5, 2011 at 12:11
  • Interesting, what does the date look like in the Mac file compared to the windows file?
    – root
    Oct 5, 2011 at 13:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .