how do I get excel to format dates before 1 jan 1900

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

Guest

I am transcribing Parish Registers for our local church. Many entries go back
to past centuries and we need to be able to search the database/table by
date. Hence need date formatting prior to 1900.

Any ideas?

Ps Using Office 2000 XL and Access
 
All dates previous to 1900 will be text in excel so you need to to search on
text


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

how do i enter a date before jan 1, 1900 into excel? 1
How can i input a date/year older than 1900, eg: 1 Jan 1822 ? 3
Incorrect Excel date 1900 is not a leap year 1/1/1901 <> 367 2
Formatting dates prior to 1900 7
How can I get Excel 2003 to display dates before 1900 2
Exporting pre-1900 dates to Access? 2
Excel having problems with dates earlier than 1900 2
How do I sort dates in Excel 3

Back
Top