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??
Date format in InSpreadsheet Browser
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Date format in InSpreadsheet Browser
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
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
Technical Director
www.infocat.co.uk
www.infocat.co.uk