Country Code in date format when output to excel

In the Birt Report, I have a data field formatted as DateTime (dd.MM.yyyy)
When the report is exported to excel, the cell-format contains a country code ([$-807]TT.MM.JJJJ)

Is there a way to avoid the country code in the cell format in excel? I would like the cell format to be the same as in the birt report.

We use excel 2007.

Thank you!

Find more posts tagged with

Comments

thuston

Is the output format XLS or XLSX?
Are you exporting from the Designer or from the Engine (iServer, iPortal, Java Components, API, etc)?

If you open in another version of Excel do you see the same?
I don't think we add that format mask, Excel 2007 may be doing it.

pasc

The export is from the webviewer in the iServer (Export content to Excel). The file format of the excel file is xls. I don't have another Office version to verify other than Office 2000, which doesn't work at all because of the xml-file structure.

I just saw that the code that is added to the format mask in excel correlates to the settings in the locale cookie that is set when visiting the iServer webpage.