Questions

dates in Xcel

Tags:
+
0 Votes
Locked

dates in Xcel

gwyn909
As a genealogist I have to often put in dates that are before 1900. Is there plugin available for Excel to do this?
  • +
    0 Votes
    Kingbackwards

    You can put any information you want into a cell. So you don't need plug-ins for that.

    If you're having trouble with it formatting properly, select the cell(s), right click go to format cells. From there you select several different formatting options for dates so that it will display in the fashion you desire.

    +
    0 Votes
    gwyn909

    I have tried to put the date 8 November 1854 into excel and all I ever get is garbage. I have discovered that the open office spreadsheet does accept pre 1900 dates very nicely without having to run a macro. So It looks like I will have to go that route and chuck excel out the window.

    However I have gone to the Spreadsheet page link and there seems to be a solution there. However, it has to be unzipped and set up and has a licence requirement.

    Yes I will go Openoffice. Thanks for the suggestions.

    +
    0 Votes
    Qus

    Try this link under add ins category:
    http://spreadsheetpage.com/

    +
    0 Votes
    ThumbsUp2

    Unless you need to sort on the date column, you don't need to format the cells as a date. You can put any 'text' into a cell and force it not to try and recognize it as a date by preceding what you type with the ' character. For example, type the following into the cell:

    '8-Nov-1854

    +
    0 Votes
    gwyn909

    Unfortunately I have to sort according to date and as you have observed that this is not possible in Excel. It is, however, possible in Open Office.

    Again Xcel has failed.

    +
    0 Votes
    oldbaritone

    The military format for dates is useful for this -
    just use an integer of the form
    yyyymmdd

    so 12-Apr-2010 is
    20100412

    It's not too difficult to format for printing, and sorting is automatic. Leap years are not a problem; they're handled automatically by virtue of the format. And you could successfully go back to 1 A.D. without any issues. I don't think too many genealogical records go back that far...

    :-)

  • +
    0 Votes
    Kingbackwards

    You can put any information you want into a cell. So you don't need plug-ins for that.

    If you're having trouble with it formatting properly, select the cell(s), right click go to format cells. From there you select several different formatting options for dates so that it will display in the fashion you desire.

    +
    0 Votes
    gwyn909

    I have tried to put the date 8 November 1854 into excel and all I ever get is garbage. I have discovered that the open office spreadsheet does accept pre 1900 dates very nicely without having to run a macro. So It looks like I will have to go that route and chuck excel out the window.

    However I have gone to the Spreadsheet page link and there seems to be a solution there. However, it has to be unzipped and set up and has a licence requirement.

    Yes I will go Openoffice. Thanks for the suggestions.

    +
    0 Votes
    Qus

    Try this link under add ins category:
    http://spreadsheetpage.com/

    +
    0 Votes
    ThumbsUp2

    Unless you need to sort on the date column, you don't need to format the cells as a date. You can put any 'text' into a cell and force it not to try and recognize it as a date by preceding what you type with the ' character. For example, type the following into the cell:

    '8-Nov-1854

    +
    0 Votes
    gwyn909

    Unfortunately I have to sort according to date and as you have observed that this is not possible in Excel. It is, however, possible in Open Office.

    Again Xcel has failed.

    +
    0 Votes
    oldbaritone

    The military format for dates is useful for this -
    just use an integer of the form
    yyyymmdd

    so 12-Apr-2010 is
    20100412

    It's not too difficult to format for printing, and sorting is automatic. Leap years are not a problem; they're handled automatically by virtue of the format. And you could successfully go back to 1 A.D. without any issues. I don't think too many genealogical records go back that far...

    :-)