Custom format (-3,4)

[Trouttrap2]

Hello all,
is there a way to custom format a number in a cell to produce (-4, in a single cell. This is half of (x,y) coordinate system. The y coordinate will be in the neighboring cell. My attempts only produce -(4, in the cell. I would like the "-" to be within the open parenthesis like this (-4,. BTW, the number 4 is any number dependent on user entry.
thank you

 

[shg]

You could format the cell as (General;(-General

 

[Trouttrap2]

That's great, SHG! I didn't know you could use general as a format option like the other chacters . Thank you.

 

[shg]

You're welcome, glad it worked for you.