Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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?

share|improve this question

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.
share|improve this answer
    
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. –  Andresch Serj Oct 5 '11 at 12:11
    
Interesting, what does the date look like in the Mac file compared to the windows file? –  root Oct 5 '11 at 13:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.