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

K

keithcarteruk

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
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
Top