Dates in spreadsheets

R

Robert Newman

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
 
G

Guest

Hi Paul B,

Many thanks for such a quick reply.
It worked brilliantly, many, many thanks.

What a great site this is, wish I had found it earlier.
Again many thanks.

Robert
 
Top