Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
1904 Date System
Posted by Mudface on October 18, 2001 1:23 AM
Argghhh, I've just finished off flexi-time sheets for several of our departments containing a myriad of formulas to correctly display negative times, when I find I could have used the 1904 date system to do it much more easily.
Before I go and re-do all the sheets, though, I have a couple of questions-
1. If I check 1904 in the options, will it stay checked when used by other people on different PC's (ie it won't revert back to the 'normal' date system)?
2. Will checking 1904 change other people's settings when using other 'normal' Excel sheets (ie will these sheets be changed to 1904, also)?
Thanks for any help you can offer. Bloody Excel :).
Just to set the record straight...
Posted by Mark W. on October 18, 2001 2:07 PM
The 1904 system isn't any less "normal" than 1900.
If fact, 1904 is the original date system... when
a Windows-based PC was still a Bill Gates dream.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.