title: Convert numbers with parentheses around to negative numbers
body: <p>I have Excel data that has parentheses around negative values, but Excel does not see them as negative values, it seems to take them as text. E.g. trying to sum cells that have ($25.00) and $50.00 gives #VALUE! error.</p>
  
  <p>The data is imported from a csv file.</p>
  
  <p>It's not a formatting issue, changing negative value formatting does not change anything. So, how do I convert these values to actual negative numbers?</p>
  
  <p>Thanks.</p>
  
  <p>Here is some sample data in case someone wants it. So the values in parentheses are supposed to be negative numbers but seem to be text at the moment.</p>
  
  <pre><code>($25.00)
   $50.00
  ($35.00)
  ($15.00)
  </code></pre>