I suppose I should read posts before answering!!

Try a Custom format of

0_);(0)

Mike

"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