This likely isn't that difficult, but I'm not getting the expected result. When the user enters a quantity in a form textbox, I would like the
resulting value be wrapped in parentheses on the worksheet.

ActiveCell.Value = "(" & txtQuantity.Value & ")"
So this should result in (2), or whatever quantity they enter. What I'm getting with this line of code as shown is -2 without ()

Thank You