You must go back into Regional Options and set "Currency" negatives to () in
order to have the () as an available format in Excel.


Gord Dibben MS Excel MVP


On Wed, 24 Feb 2010 10:05:01 -0800, AJW30
wrote:

Having chosen the ( ) format for negative numbers via the Regional/Keyboard
options in the Control panel, this still does not show as an option in the
normal list of number formats. Negative numbers on a spreadsheet just appear
with a minus sign. Any reason? I have tried the Conditional Formatting but
the end result is a number appearing as -(x,xxx.xx). I don't wish to see the
minus sign. I'm using Excel in Office 2007 with Windows 7