I've exported data from Active Directory and imported the resultant .csv file into MS Excel. All the dates and times are displaying in MS Excel in Engineering Notation format and are of no use in this format.
How can I get the dates from Active Directory such that they display correctly? Or how can I use MS Excel to view the correct date in the appropriate format.
I tried changing the column format. Didn't work. I also tried to change the field type to "Date" when importing the data.csv into excel.
Specifically looking for date fields like "LastLogon" or "modified". Getting 1.32314E+16 where it should read 3/14/2014 or something similar.