InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 17:29:48 GMT20http://www.sqlservercentral.com/Forums/Topic1424856-17-1.aspxPretty sure there isn't a setting to fix this in the cube - it sounds like Excel is auto-converting this not SSAS telling Excel that it's a numberThe only thing I can think that you could do is have an attribute of the date that is a number (yyyymmdd) and include that on the drilldown rather than the long dateMackFri, 01 Mar 2013 09:56:04 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1424856-17-1.aspxAlso, when I view the cube in management studio and perform the drillthrough there, the data type doesn't change. Only when it is in excel.Wed, 27 Feb 2013 20:30:25 GMTmichaeleusebio721http://www.sqlservercentral.com/Forums/Topic1424856-17-1.aspxHi Guys,I'm adding a drillthrough action on my cube. The measure displays in DATE on the field. I then created a drillthrough and added the measure to the drillthrough columns and when I perform the drill through action on excel it converts to INT.2/14/2013 22:51 gets converted to 41319.95241Am I missing any setting or property in the drillthrough?Please help.Thanks!Wed, 27 Feb 2013 20:26:26 GMTmichaeleusebio721