View Single Post
  #1   Report Post  
keithcarteruk
 
Posts: n/a
Default how do I get excel to format dates before 1 jan 1900

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