title: How can I set contents of a spreadsheet cell to Accounting format with EPPlus?
body: <p>I need to set the contents of certain columns to Accounting format.</p>
  
  <p>This attempt:</p>
  
  <pre><code>public static readonly string NUMBER_FORMAT_ACCOUNTING = "$";
  . . .
  bidPriceCell.Style.Numberformat.Format = NUMBER_FORMAT_ACCOUNTING;
  </code></pre>
  
  <p>...simply gives "$" and "-$" as the values.</p>
  
  <p>This attempt:</p>
  
  <pre><code>public static readonly string NUMBER_FORMAT_ACCOUNTING = "$0.00";
  . . .
  bidPriceCell.Style.Numberformat.Format = NUMBER_FORMAT_ACCOUNTING;
  </code></pre>
  
  <p>...gives me values such as, "$24.09" and "-$0.91"</p>
  
  <p>What the user wants is space between the dollar sign and the value, and parens around negative values, such as "$  24.09" and "$ (0.91)"</p>
  
  <p>What string do I need to assign the Numberformat.Format property for this to work?</p>