title: Changing currency symbol in SQL Reporting 2005
body: <p>I'm using SQL Reporting 2005. I'm formatting a currency in a cell using</p>
  
  <pre><code>Format(Fields!NetPrice.Value, "C")
  </code></pre>
  
  <p>but the format is coming out</p>
  
  <pre><code>$10.00
  </code></pre>
  
  <p>I want pounds so</p>
  
  <pre><code>£10.00
  </code></pre>
  
  <p>Can someone tell me where is the setting to do this. I've looked and google and can't find it. Is it obvious? I want to set it on the report level if possible and not alter SQL Server settings due to minimise impact elsewhere.</p>
  
  <p>I could cast the currency to a string and add <code>"£"</code> I guess but I want to do it properly. </p>