Excel does not have a DateTime category by default for showing data. However, you can use the “Custom” option in format cell window to select the way you want to parse and show the data.
In order to format a column to show data in datetime format, select the column, From the HOME tab expand the Number Format dropdown (grouped under number) and click More Number Formats.
Then go to the Custom section (at the bottom of the list) and type your custom format as following:
Your data will now be shown in DateTime format. For example 29-04-2014 10:05:42.187