Yes many thanks Fredrik. That will do it fine. Pete
Thanks to all respondents.

"Fredrik Wahlgren" wrote:


"Pete the Mag" wrote in message
...
Thanks but,
I should have correctly posed the question as:
I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834,
and be able to sort them into chronological order. Can this be done?


Yes. Let's say you have entered '14/02/1834 in A1 and downwards. Copy the
column and paste the values to column B.
Now, select column B and use Data|Text to columns. The wizard is easy to
understand. The dates will be split to thre columns.
Select columns A to D and select Data|Sort. Sort first on D, then on C and
then on B. When you're done, you an delete columns B to D.

/Fredrik