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

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