LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Phil
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Excel default date format mjk Excel Discussion (Misc queries) 1 August 16th 05 10:52 PM
Default date formats J Fultz New Users to Excel 6 April 27th 05 09:53 PM
How do I reset default Excel window too view=fullscreen needyourhelp Setting up and Configuration of Excel 4 March 7th 05 10:37 PM
Excel Default date for date format smurphy123 Excel Discussion (Misc queries) 3 January 23rd 05 09:39 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"