[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

why can't I sort this by internment date

Posted on 2016-10-08
1
Medium Priority
?
73 Views
Last Modified: 2016-10-08
when I try to sort this by internment date, it won't do it.  What is wrong?
20161008-cemetery.ods
0
Comment
Question by:dwcronin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
Ejgil Hedegaard earned 2000 total points
ID: 41835303
Some of the dates are not dates, but from row 2022 down it is text that looks like dates.
In Excel I would select the range A2:A3355 and use text to column.
Then it will be converted to dates, except the last 3, where the day value is 0.
Then you can sort.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question