Results 1 to 3 of 3
  1. #1

    Member Since
    Jan 14, 2010
    Help with excel sheet copy question please
    Recent convert here.

    When I am need to copy a excel sheet to a new workbook, the date in the sheet that I am copying to new book does not stay the same. For example, I am copying a sheet with date 1/8/2010 in a cell. On the new sheet that is copied to a new workbook, that date changes to 1/9/2014. All of the other data on sheet stays the same but all the dates on the page change. Other dates at the bottom of the page advance to 1/8/2013.

    If I perform this on a PC, all of the dates remain the same. I just talked to another recent convert and he has the same problem.

    I am going nuts trying to figure this one out.
    Any ideas???

  2. #2

    nabl's Avatar
    Member Since
    Dec 13, 2007
    United States of America
    2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09
    Excel stores dates internally as the number of days since a base date. The problem for you is that the base date is different between the Windows and Mac versions of Excel: on Windows, the base date is January 1, 1900, while on Macs it's January 2, 1904. So what's happening is that the same number of days is being counted, but it's being added to a different date. You can read more about it in Excel's documentation for the DATE function.

    To fix it (on a per-workbook basis), choose Excel > Preferences from the menu bar and then click the Calculation section. Uncheck the Use the 1904 date system option and you should be good to go; just keep it in mind when using dates and transferring files between Windows and Mac users.

  3. #3

    Member Since
    Mar 30, 2004
    12" Apple PowerBook G4 (1.5GHz)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can not unlock excel sheet
    By Nikkeh in forum macOS - Apps and Games
    Replies: 2
    Last Post: 08-05-2014, 02:26 PM
  2. Can not unlock excel sheet
    By Nikkeh in forum macOS - Apps and Games
    Replies: 3
    Last Post: 08-05-2014, 11:38 AM
  3. Can not unlock excel sheet
    By Nikkeh in forum macOS - Operating System
    Replies: 1
    Last Post: 08-05-2014, 11:13 AM
  4. Newbie question...excel sheet to pdf
    By McKoep in forum Switcher Hangout
    Replies: 3
    Last Post: 07-17-2013, 02:48 AM
  5. Excel Spread Sheet!
    By fncos in forum macOS - Apps and Games
    Replies: 14
    Last Post: 05-25-2010, 08:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts