Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reset default 01/01/1900 date
Is it possible to reset the default base of 1/1/1900 to a substantially
earlier date (say 1/1 1700). The reason for asking is that in most genealogical research into families, we are woking with dates in the 17th and 18th centuries. The current default means is is impossible to sort on these dates in an Excel Spreadshet |
#2
|
|||
|
|||
Phil,
Use John Walkenbach's XDATE addin (eXtended DATE), available at http://www.j-walk.com/ss/excel/files/xdate.htm HTH, Bernie MS Excel MVP "Phil" wrote in message ... Is it possible to reset the default base of 1/1/1900 to a substantially earlier date (say 1/1 1700). The reason for asking is that in most genealogical research into families, we are woking with dates in the 17th and 18th centuries. The current default means is is impossible to sort on these dates in an Excel Spreadshet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Excel default date format | Excel Discussion (Misc queries) | |||
Default date formats | New Users to Excel | |||
How do I reset default Excel window too view=fullscreen | Setting up and Configuration of Excel | |||
Excel Default date for date format | Excel Discussion (Misc queries) |