brackets around numbers problem

hi i have this code that goes to an excel file look or a word and copies the value i want here is the code

Code:

---

oRng = oWSSheet.Cells.Find("UNREALIZED GAIN - FVTPL_HFT_FT (SHORT) (19611104)", , _
                      Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
                      Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
        ' MsgBox("Value '" & oRng.Value & "' found at '" & oRng.Address)
        Me.UNGFts = oRng.Offset(0, 5).Value
        oRng = Nothing

---

some of the numbers have brackets around it. how can i get it to remove brackets or ignore them so it picks the value up right
thanks

I believe Excel represents negative number with brackets.

ok thanks