Categories
Date format is changing when downloaded in excel 2007
Hi ,
I am using OBIEE 11.1.1.9 .After export to Excel, the date column is suddenly shown in a different format which leads to misinterpretation: 3-13-2017 instead of 13-3-2017. Can anybody tell what is the real cause ?
Thank you.
Answers
-
OBIEE 11.1.1.7.150120 - EXCEL 2007+ Exports Wrong Date Format For Non-ENU (Doc ID 2007856.1)
There are three workarounds:
• Export to Excel 2003 and then save file as Excel 2007+ format (.XLSX)
• Export the data to Excel 2007+ and then change the format of the exported date cells to the correct dd/mm/yy format in Excel 2007.
• Change the date format of the column in the Analytics criteria column properties to a custom format dd/mm/yy and the export to Excel 2007+ keeps the custom format
HTH-
Jasmine
0 -
I changed it to custom format and saved it as system wide default .
0 -
Does it work now?
HTH-
Jasmine
0 -
Yes that is working now
0 -
Can you please mark the question as answered/helpful and close the post? That will avoid people from opening up the post to answer
HTH-
Jasmine
0 -
This workarounds: "Export to Excel 2003 and then save file as Excel 2007+ format (.XLSX)" does not work anymore. Export to Excel 2003 no longer possible (OBIEE 11.1.1.9.0). I use the third workaround.
0