title: Format Currency into millions of dollars SQL Server
body: <p>Can anyone help me format my dollars data into millions of dollars for SQL Server?</p>
  
  <pre><code>3,000,000
  
  --&gt; $3M
  </code></pre>
  
  <p>I have this but it's not working</p>
  
  <pre><code>SELECT     '$' + SUM(Sales_Information.Sales_in_Dollars / 1000000) 
                        AS [Sales in Millions]
  </code></pre>
  
  <p>Doing this gives me #Error</p>
  
  <pre><code>format(SUM(Sales_Information.Sales_in_Dollars / 1000000)
  </code></pre>