Exporting DATES to Excel

[anaves]

There is a weird behavior ( BUG ? ) when exporting DATES to Excel in a machine with Portuguese Language and date format as dd/mm/yyyy.
1- If the DAY of a exported date is less than 12, cells in Excel are exported as date but having mm/dd/yyyy as format.
2- If the DAY of a exported date is greather then 12, cells in Excel are exported as GENERAL format as "dd/mm/yyyy ".
Changing the machine configuration to American English and date format to mm/dd/yyyy the exported dates are always in dd/mm/yyyy, but still days until 12 exported as dates and greather then 12 as GENERAL format.
I've tried dd-mm-yyyy format and the behavior was the same.

Please let me know if I can help in any way.

[AlexZencovich]

I do not sure if it possible. I have read much internet forums related to that problem. It is known and old problem with MS Excel. There si only one way out - open excel table and change column type to string then back to date. But it cannot be done from export routine because it is very complex understand when dimension is date. I will try to see if this is possible but if dimension has custom groups it may break export