title: SSAS - How to configure format number for calculated measures?
body: <p>I created a calculated measure in order to allow user to display the operating margin about sales.</p>
  
  <pre><code>ROUND([Measures].[Total] - [Measures].[Total Cost],2)
  </code></pre>
  
  <p>It works well, however I get an error when I try to retrieve the data in Excel / PowerPivot.
  In fact, It displays values by using the ",." format to separate decimals and my format is " ,). So how to configure to change this behavior in SSAS because Excel cannot format the number due to a "unknown type" (it cannot parse the number).</p>
  
  <p>This an example of decimal conversion from US to French format :</p>
  
  <pre><code>1,000,000.00 (US) -&gt; 1 000 000,00 (France) 
  99.99 (US) -&gt; 99,99 (France)
  </code></pre>
  
  <p>OK I could replace the "dot" by a "comma" directly in Excel but it's not a good practice and the objective is to simplify the PowerPivot usage.</p>
  
  <p>Thanks !</p>