Questions

dates in Xcel

+
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...

:-)