Modify date / time field

Modify date / time field

Hi there
 
So far I am a happy user when it comes to AD Audit, and it has been a great help with making things visible within AD.
 
However there is one thing that I can't seem to sort out.
 
When I run a report, for example recently deleted users, and export the data to XLS the column called "Deleted Time" has the following format.
 
Dec 01,2010 11:02:04 AM
 
This format does not give me a lot to play around with to filter out more detailed information.
 
Text to columns with a space as as seperator will separate some columns but the , in between the 01 and 2010 needs additional work. Also the notation Dec does not make sorting easier when other month names are involved.
 
Basically, and what would work for me is, if the time stamp can be separated from the data stamp, perhaps a new column, and that the date stamp is a numeric notation, for example 12.01.2010 or 12-01-2010
 
It also does not seem to be influenced by the local settings of the computer. Currently it generates quiet some work for me to sort out further details.
 
Any suggestions, help, hints and tips?
 
Is something like this possible with the version I am currently running?
 
License type:  Standard - Registered Version
Licensed to:  Tommy Hilfiger Europe BV
Product name:  ManageEngine ADAudit Plus
Product version:  4.0.0
Build no:  4052
 
 

                New to ADSelfService Plus?