MS Excel Date problems?

Discussion in 'Mac Apps and Mac App Store' started by jrober, Mar 19, 2007.

Most Liked Posts
  1. jrober, Mar 19, 2007

    jrober macrumors regular

    jrober

    Joined:
    Jan 22, 2003
    Location:
    Heathfield, UK
    #1
    All,

    I am using a Powerbook G4 with 10.4.9 and running Microsoft Excel 11.3.3.

    I have just opened a spreadsheet to find that all the dates now read 2010 instead of 2006 and they are 1 day out as well e.g. Tuesday 10th Oct 2006 now reads Monday 11th Oct 2010.

    Q1 Anyone else find issues with recent upgrades e.g. 10.4.9 or MS security upgrades

    Q2 Anyone know of a systematic way to sort these out? I have 200 different dates to correct!

    Thanks in advance.

    John

    EDIT - All dates had 1462 added to them? Now fixed but don't know of problem source. This was not confined to one spreadsheet.
     
    share
    + Quote Reply
  2. iSaint, Mar 19, 2007

    iSaint macrumors 603

    iSaint

    Joined:
    May 26, 2004
    Location:
    South Mississippi y'all, near the water!
    #2
    I swear there was a long thread at one point about issues with dates in Microsoft Office. I can't find it. Have you searched the forums?
     
    share
    + Quote Reply
  3. Applespider, Mar 19, 2007

    Applespider macrumors G4

    Applespider

    Joined:
    Jan 20, 2004
    Location:
    looking through rose-tinted spectacles...
    #3
    It's to do with the difference in the two different dates between Windows and Macs that Excel starts counting from. The Windows version starts from 1900 and the Mac version starts in 2004. They're a day out because of the leap year issues.

    Under Calculation Preferences you can tell Excel to use 1904 dates or not. It may be that the recent update checked or unchecked it.

    If you're using lots of spreadsheets started in Windows, I'd probably uncheck it.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page