TM1 Forum

Hello,
Can anyone shed some light on this date format problem in the InSpreadsheet Browser.
In the View, the date is in dd/mm/yyyy.When I snapshot it to Excel, it comes across as dd/mm/yyyy.But when I select Browse in Excel, it shows mm/dd/yyyy. How can I fix this??

I think the ISB formatting is done using Styles.

It's possible the default format style ofr your excel session is set to the american style date format. You can access the styles from the Excel menu bar Format, Styles.
HTH