Occasionally, dates are displayed in the wrong format when exporing a report to Excel. To correct this issue, take the following steps. 





1. Highlight the column or cells.




2. Depress Ctrl + Shift + 3. This will correct the date format.




Alternately, right-click on the cells in question and select "Format Cells" from the popup menu. 



Select "Date" and then choose the preferred date format from the list.