All dates previous to 1900 will be text in excel so you need to to search on
text


Regards,

Peo Sjoblom

"keithcarteruk" wrote in message
...
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