Excel export of Report showing "tt" in place of AM/PM

 I have a report with date columns and we have formatted this date with this format "dd-MMM-yyyy hh:mm:ss tt". In the portal view, the report is showing the correct date format. But when I download the report, it is showing the date field with "tt" at last of it. Reports with date columns formatted with format "dd-MMM-yyyy hh:mm:ss tt" are showing "tt" in place of AM/PM in Excel on exporting.

Sign In or Register to comment.