brackets around numbers problem

[rjhe22]

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

 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

[Niya]

I believe Excel represents negative number with brackets.

[rjhe22]

ok thanks