Hello!
I have just installed Office 2016 (corporate installation) at work and now I have this problem:
I run a report with my Quest Reporter (I think now it's known as Dell Reporter) to get a listing of Active Directory accounts. One of the attributes I need is the Last Logon Date.
The format of the report is either Comma or Tab delimited (I've trued both and I get the same result as below) - so, a text file.
I then proceed to open the text file in Excel, with one column showing all the dates in the following format (example):
7/8/2016 10:43:16 AM
4/6/2016 12:54:52 PM
10/31/2016 8:32:59 AM
When I sort that column, the values are taken as if they were text, therefore I get this result:
10/31/2016 8:32:59 AM
4/6/2016 12:54:52 PM
7/8/2016 10:43:16 AM
When I was expecting this:
4/6/2016 12:54:52 PM
7/8/2016 10:43:16 AM
10/31/2016 8:32:59 AM
Using the Right+Click, Format cells... and choosing another format for Date doesn't make any difference.
I've also tried copy+Paste Special... all the different types of Paste : Same result.
This never happened before - That report I run it monthly and no changes in the Quest Reporter or Active Directory have been performed, therefore the resulting data from that report is the same as before.
Anybody have any idea how can I resolve this?
Thanks!
Bookmarks