In Excel dates are shown as serial values.
(*The Excel serial value 1 corresponds to January 1, 1900.)
Excel stores dates as sequential serial numbers so that they can be used in calculations.
In order to change the date format, right click on the selected date column and choose "Format Cells", then select Date under Category and the desired type.
September 02, 2016