Do not re-install Office or Excel.
If negative brackets are not available in the Number>Negative Numbers dialog.
This is a function of your Regional Settings in Windows OS.
Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)
Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.
Apply and OK>Apply your way out.
Gord Dibben Excel MVP
On Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install
Gord Dibben MS Excel MVP
