How do I sort dates in Excel

L

Lorene Schertzl

I am transcribing a cemetery and want to be able to sort by birth date and
death date. I have already entered the dates as year-month-date all numbers.
(yyyy-mm-dd). eventually it will be posted on line and will be a little
confusing to read that way. I would rather have it read day month and year
(06-May-1889) with or without the -

Is there any way that I can change everything, short of going back and
redoing the whole thing?

If there is any way I need simple complete direction's.
 
A

Ardus Petus

Once you have entered the dates, Excel maintains them internally as a number
of days sice 01/01/1900.

You can format thes dates the way you like, this will only show different
formats, not change the internal dates.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort dates in Excel 3
Date and years calculation 2
Cemetery birth and death date sort 1
Displaying two dates in excel 1
Date Format and Sumproduct 9
Problem sorting by date after 2029 on Excel 2003 1
Formatting Dates from Text to Numbers 2
Sort dates Excel 2007 2

Top