how to remove parentheses for negative number in excel
<p>I am trying to remove parentheses for negative numbers in excel, but I have so far been unable to remove them successfully</p>

<p>I tried below code:</p>

<pre><code>sheet1.UsedRange.Select
sheet1.Range("A:XFD").NumberFormat = "0.00"
objExcel.ActiveWorkbook.PrecisionAsDisplayed = True
</code></pre>

<p>but it only works after doing <code>TextToColumns</code> manually. I need a more general solution, as I don't always know which rows have numbers.</p>