Excel mystery

Discussion in 'Mac Apps and Mac App Store' started by bigboy99, Aug 29, 2007.

  1. bigboy99 macrumors 6502

    Joined:
    Nov 12, 2005
    Location:
    Deep in the Heart of Tejas
    #1
    I'm trying to copy from one workbook to another (rows, and/or entire sheets) and the date keeps changing when the action is completed. It moves up one day, and also up four years (3/20/01 becomes 3/21/05.) All other info copies & pastes okay.

    UPDATE

    Just unchecked the 1904 date system box in Preferences/Calculations, and all seems to be working correctly now.
     
  2. yadmonkey macrumors 65816

    yadmonkey

    Joined:
    Aug 13, 2002
    Location:
    Western Spiral
    #2

Share This Page