Skip to main content

Change Date Format in Excel Reports

Updated

Change Date Format in Excel Reports

1. Download file and open in Excel

2. Highlight cells containing dates
mceclip3.png
3. On the Data  tab, click Text to Columns
mceclip4.png

4. Click Next on step 1
mceclip5.png

5. Click Next on step 2
mceclip6.png

6. Select Date and MDY on step 3, then click Finish
mceclip7.png

7. Excel will bring you back to your spreadsheet.

mceclip8.png

8. With the dates still highlighted, right click on the highlighted area and select Format Cells
mceclip9.png

9. Choose the desired date format and click OK
mceclip10.png

10. Date format has been changed
mceclip11.png

Powered by Zendesk