Odd... if you go to the report properties and then column -> manage, on the right side do you see any format options you can change?
Exporting projects to excel yields inconsistent date formats
When I export a list of projects to Excel, the downloaded Excel file has multiple different formats for the same date column. I see mm-dd-yy and mm-yy-dd. How can this be resolved? I can't use the Text to Columns feature to ensure the date formats are correct because the same column has multiple formats.
Please sign in to leave a comment.