Excel question
I'd be grateful for help with an Excel problem.
I've been sent a spreadsheet in which one of the columns is Date of Birth.
The list is currently in alphabetical order by surname.
I need to sort by DoB.
My attempts to do so have been unsuccessful because the DoB format is 04/11/1962 etc and sorting by DoB produces a list starting with people born on the 1st and ending with those born on the 31st.
Is there a way of resolving the problem?
If so, can it be done without having to change each DoB entry individually? (There are almost 2000 names so that isn't practical.)
Thanks.
FL