I cannot sort my spreadsheet

I cannot sort the following spreadsheet by internment (buriel - colum C) date.  How do I fix it?  fyi my sister manages the local cemetery.  I asked this before and the solver said the items in C were not the same format.  I gave him the points but couldn't get them all the same format.  seems simple but I cannot fix it
dwcroninAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
It seems simple. In Excel, highlight the entire column, select Format, Format Cells and give all cells the same format (say date) . That normally works for me.
Gerwin Jansen, EE MVETopic Advisor Commented:
You can change the type of that column to General / Text and as long as you enter the date using the same format, you should be able to sort. I can recommend a text 'date' that looks like this: 20151003 (for the current date October 3rd).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jmcgOwnerCommented:
You may have to use the text conversion tool to convert dates in diverse formats into spreadsheet dates.

The only trouble might be if the dates are written with conflicting conventions so that some dates are ambiguous. If the dates can't be converted automatically, and there's no easy pattern match/replace that can fix them, then you may be stuck conforming the dates by hand.
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

dwcroninAuthor Commented:
I'm sorry but I got interrupted yesterday before I could include the file.  Near row 1137, an apostrophe appears before the internment date.  The sheet doesn't sort by column C with the apostrophe.  What should I do to get rid of it?  While writing this file, I think I used LibreOffice Calc and Google Sheets to write this..
20151004-cemetery.ods
Gerwin Jansen, EE MVETopic Advisor Commented:
An apostrophe means that you you type will be treated as text, in this case the date. Just edit the cell and remove the apostrophe at the beginning of the cell. Then try the sort again.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>I cannot sort the following spreadsheet by internment (buriel - colum C) date.  How do I fix it?
check row 1593, it seems that there was an invalid date entry, try to fix that and then see if your sorting issue can get resolved?

invalid date
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.