I am entering family information in a spreadsheet and
entering dates as for example 23 Nov 2004. However these
are not recognised as dates if year is before 1900 and
hence I cannot sort on date. Is there a way to overcome
this please?

Robert