Date format in InSpreadsheet Browser

Post Reply
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

Date format in InSpreadsheet Browser

Post by telula »

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??
User avatar
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

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
Post Reply