7 replies
by gwyn909 Accepted solution
by kingbackwards Accepted solution
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.
by gwyn909 Accepted solution
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.
by qus Accepted solution
Try this link under add ins category:
http://spreadsheetpage.com/
by thumbsup2 Accepted solution
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
by gwyn909 Accepted solution
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.
by oldbaritone Accepted solution
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...
:-)
This discussion is closed to new replies.
Trending Software posts
Sort by Trending