SSAS Calculation Formatting Not Showing in Excel 2007 or Excel 2010
Occasionally in SQL Server 2005 and 2008 Analysis Services, you'll build a cacluation and set the formatting to be a value like a currency and are surprised that in Excel 2007 and 2010 the formatting does not carry over. The "randomness" of this actually does have a bit of a method behind it. The formatting issue that you see in browsers like Excel is because Excel is looking for the type of language that you want to display the currency format. In other words, should Excel show GB Pounds or US Dollars? You'll see the behavior when creating calculations and you specify currency for example in BIDS as in the below screenshot.