Format Date for Exported Reports in Excel

When a CSV file is exported, you may want to format the date column to a preferred format for easier readability.

Make Sure the Column is Wide Enough

If the column is too small, the date will show as #######.  Drag the right side of the column header to widen the column.

Format Date in Excel

1. Open the exported report CSV file in Excel
2. Highlight the cells or columns containing the dates
3. Press CTRL+1 to open the Format Cells window
4. In the Format Cells box, click the Number tab
5. In the Category list, click Date
6. Select the Type you would like to show:
   
   
   
7. Click OK
8. Save the report as an Excel Workbook (.xlsx) to save the custom formatting