Formatting Column in Excel to show DateTime

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:

dd-mm-yyyy hh:mm:ss.000

Your data will now be shown in DateTime format. For example 29-04-2014 10:05:42.187

Author: Dev

Full Stack Developer at one of the largest Banks in Canada.