Could you try using a custom format, something like:

0.00_);-(0.00)

Note that the part after semicolon is how you want to format negative
numbers (in front of semicolon is how to format positive numbers)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nadine" wrote:

Excel 2007 - display negative numbers with minus sign and parentheses

We go into format cells - select number - and there are only black or red
choices with or without a minus sign. Don't have any of the choices with
parentheses,

In excel 2003 have choices with parentheses in format cells - number

Is this feature gone in Excel 2007, search help and the help says - with or
without paretheses, but when following instructions there are no options for
parentheses are showing.

OS is Vista Enterprise