Forum Discussion
Solved
Datetime column is in AM/PM format after export to Excel
Hello to the forum, I am exporting data from a matrix in a published Power BI report to Excel. In the visualization there is a column in datetime format. This is displayed in Excel in AM/PM forma...
My suggestion is not to use "General Date". I would scroll down the list and pick a specific format.
Hello Anonymous ,
thanks for your answer!
In Power BI Desktop, the column also has a date/time format without AM/PM. The data type is also
date/time. So that can't be the problem.
The column in Power BI Desktop
Do you have any other idea why the Excel file is in AM/PM format?
My suggestion is not to use "General Date". I would scroll down the list and pick a specific format.
Thank you Anonymous ,
that was helpful!