Sarah,

I may have confused you with my first and incorrect post.

With the number -1234 in a cell select that cell then:-
Format|Cell|Number
Select custom and paste in the formula
0_);(0)
Click OK and theminus sign will turn to (1234)

Mike


"Sarah" wrote:

Mike that didn't work. I got 1,716,536,781,789

I just want to put brackets round my minus number but all I get is the minus
sign. Any more ideas??

"Mike H" wrote:

Hi,

Put -1 in a cell and copy it. Select the cell with -3210 in and then

Edit|Paste special
Select multiply and OK.
Delete the cell with -1 in

Mike

"Sarah" wrote:

I trying to change -3210 to (3120) but can't find how to do it. Can anyone
help me? I'm using the 2003 version. Thanks