Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Spreadsheet which will do dates before 1900
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Neo" data-source="post: 542442" data-attributes="member: 36256"><p>I'm using Excel 2004 for this answer.</p><p></p><p>You guys have a problem, but just don't know it yet. And the problem crops up for dates before Jan 1, 1904, not 1900. Spreadsheets store dates as numbers. For example, today (December 5, 2007) is day 37959, counted from January 1, 1904 (which is day zero). To see this for yourself, enter the number zero in a cell, then change the cell's Number format to Date, rather than General. Or enter today's date as 12/5/2007 and Excel will change the format to Date automatically. Now go back and type 0 in that cell and it'll display 1/1/04 (it means 1904 but, in typical Excel fashion, it's not clear). Since dates are numbers, you can use math functions with them (add seven to a Wednesday date to get next Wednesday's date, for example). Oh, and using negative numbers doesn't work. Entering -21,000 is displayed as -June 30, 1961. Not especially helpful.</p><p></p><p>You can enter, for example, 4/6/1830 and it will display it as that on the sheet but it will be text format, not a number and not subject to math functions, which might be important in genealogical applications (calculate age at death, e.g.).</p><p></p><p>patricci, for anything related to family history stuff, I'd leave Excel alone and use Personal Ancestral File (PAF) instead. It's super-powerful for anything you'd want to do. You can download it for free at familysearch.org. I downloaded it (~10MB) with dialup.</p><p></p><p>EDIT: oops. I just realized PAF's not supported on Mac. When I use it, I need to start Windows first. Is that a problem? You could use Fusion to run Windows on your Mac.</p><p></p><p>EDIT: I just checked NeoOffice and its "Zero-Day" is December 30, 1899, so there you go: a spreadsheet which will do dates before 1900! More importantly it will do negative numbers correctly: -21,000 displays as July 2, 1842.</p><p>NeoOffice is a 140MB download, but you could download the .dmg with broadband access (public library?) and burn it to a CD, or I saw at NeoOffice site they offer a download manager to resume long downloads...good luck!</p></blockquote><p></p>
[QUOTE="Neo, post: 542442, member: 36256"] I'm using Excel 2004 for this answer. You guys have a problem, but just don't know it yet. And the problem crops up for dates before Jan 1, 1904, not 1900. Spreadsheets store dates as numbers. For example, today (December 5, 2007) is day 37959, counted from January 1, 1904 (which is day zero). To see this for yourself, enter the number zero in a cell, then change the cell's Number format to Date, rather than General. Or enter today's date as 12/5/2007 and Excel will change the format to Date automatically. Now go back and type 0 in that cell and it'll display 1/1/04 (it means 1904 but, in typical Excel fashion, it's not clear). Since dates are numbers, you can use math functions with them (add seven to a Wednesday date to get next Wednesday's date, for example). Oh, and using negative numbers doesn't work. Entering -21,000 is displayed as -June 30, 1961. Not especially helpful. You can enter, for example, 4/6/1830 and it will display it as that on the sheet but it will be text format, not a number and not subject to math functions, which might be important in genealogical applications (calculate age at death, e.g.). patricci, for anything related to family history stuff, I'd leave Excel alone and use Personal Ancestral File (PAF) instead. It's super-powerful for anything you'd want to do. You can download it for free at familysearch.org. I downloaded it (~10MB) with dialup. EDIT: oops. I just realized PAF's not supported on Mac. When I use it, I need to start Windows first. Is that a problem? You could use Fusion to run Windows on your Mac. EDIT: I just checked NeoOffice and its "Zero-Day" is December 30, 1899, so there you go: a spreadsheet which will do dates before 1900! More importantly it will do negative numbers correctly: -21,000 displays as July 2, 1842. NeoOffice is a 140MB download, but you could download the .dmg with broadband access (public library?) and burn it to a CD, or I saw at NeoOffice site they offer a download manager to resume long downloads...good luck! [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Spreadsheet which will do dates before 1900
Top