Convert Last Seen Date/Time in Audit report to just Date

dean.barnard
dean.barnard Member Posts: 1 ✭
in Reporting

When I use the Audit to export all of a customers machines, I want to the sort it by the Last Seen Date in Excel, but because the format is similar to October 21, 2024 9:15:10 AM it always sorts as a text field. Excel doesn't recogize it as a date field (even if I say 'Format as date'). I had put this is a feature request but assume that it's not high on the list. The only way I've found to get round this is copy it to a Google Sheets Spreadsheet and covert it (which it does quite happily) and copy it back.

Has any one managed to easily covert it to a date in Excel itself?

Thanks
Dean

Tagged:

Topics