+ Reply to Thread
Results 1 to 4 of 4

Changing base date?

  1. #1
    Aaron Bratcher
    Guest

    Changing base date?

    I was copying data from an opened CSV into a template and noticed that
    the all of the dates were wrong!

    I changed the numeric format to general in both windows to see if the
    base number was the same. They were

    I then changed the number to 0 then formatted it as a date and saw one
    spreadsheet format the zero as "1/0/1900" and the other spreadsheet
    formatted the zero as "1/1/1904"

    What gives?


    Thanks.

  2. #2
    Peo Sjoblom
    Guest

    Re: Changing base date?

    One computer is using the 1904 date system under tools>options>calculations


    Regards,

    Peo Sjoblom

    "Aaron Bratcher" <[email protected]> wrote in message
    news:[email protected]...
    > I was copying data from an opened CSV into a template and noticed that
    > the all of the dates were wrong!
    >
    > I changed the numeric format to general in both windows to see if the
    > base number was the same. They were
    >
    > I then changed the number to 0 then formatted it as a date and saw one
    > spreadsheet format the zero as "1/0/1900" and the other spreadsheet
    > formatted the zero as "1/1/1904"
    >
    > What gives?
    >
    >
    > Thanks.




  3. #3
    Ken Wright
    Guest

    Re: Changing base date?

    http://cpearson.com/excel/datetime.htm

    1/3 way down page, see

    The Two Date Systems Of Excel


    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "Aaron Bratcher" <[email protected]> wrote in message
    news:[email protected]...
    > I was copying data from an opened CSV into a template and noticed that
    > the all of the dates were wrong!
    >
    > I changed the numeric format to general in both windows to see if the
    > base number was the same. They were
    >
    > I then changed the number to 0 then formatted it as a date and saw one
    > spreadsheet format the zero as "1/0/1900" and the other spreadsheet
    > formatted the zero as "1/1/1904"
    >
    > What gives?
    >
    >
    > Thanks.




  4. #4
    Dave Peterson
    Guest

    Re: Changing base date?

    Saved from a previous post:

    One workbook was using a base year of 1900 and the other was using 1904.
    (tools|options|calculation tab|1904 date system)

    One way to add those four years back is to find an empty cell, put 1462 into
    that cell.

    Copy that cell.

    Select your range that contains the dates. Edit|PasteSpecial|click Add (in the
    operation box).

    You may have to reformat the cell as a date (mine turned to a 5 digit number).
    But it should work.

    You may want to do it against a copy...just in case.

    (I'm not sure which one you'll fix. You may want to edit|pastespecial|click
    subtract.)

    Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as
    the base date.


    Aaron Bratcher wrote:
    >
    > I was copying data from an opened CSV into a template and noticed that
    > the all of the dates were wrong!
    >
    > I changed the numeric format to general in both windows to see if the
    > base number was the same. They were
    >
    > I then changed the number to 0 then formatted it as a date and saw one
    > spreadsheet format the zero as "1/0/1900" and the other spreadsheet
    > formatted the zero as "1/1/1904"
    >
    > What gives?
    >
    > Thanks.


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1