reset default 01/01/1900 date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help! date showing as 1900/01/00 2
Dates pre 1900 1
00/01/1900 1
supress 01-01-1900 3
Formatting Dates from 1700 & 1800s 1
0/01/1900 2
Excel dates prior to 01/01/1900 2
date corruption? 00/01/1900 1

Back
Top