Report in xlsx in Report Editor

Greetings, Background: I am attempting to export a report in Report Editor that contains a datetime field and  would like to export the field in excel/csv as a date format. When the report is exported into csv, my fields displays a string and not as a datetime. The user would have to perform an extra step and use the excel function for 'Text to Columns' to convert the columns to a date. I have tried exporting in xls and xlsx formats.In xlsx/xls format, the column changes successfully to datetime but my column breaks. Is there any way to avoid the excel file to format the columns?

Parents Reply Children