- Follow via:
- RSS
- Email Alert
Question
Answers (4)
0
Votes
A little more information
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.
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.
9th Apr 2010
Replies
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.
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.
gwyn909
10th Apr 2010
0
Votes
Free add ins
Try this link under add ins category:
http://spreadsheetpage.com/
http://spreadsheetpage.com/
10th Apr 2010
0
Votes
re: Dates
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
'8-Nov-1854
Updated - 11th Apr 2010
Replies
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.
Again Xcel has failed.
gwyn909
12th Apr 2010
0
Votes
Military format date
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...
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...
12th Apr 2010
