Cameron

Don't know what you have tried but this is the standard fix if negative
brackets are not available in the NumberNegative Numbers dialog.

This is a function of your Regional Settings in Windows OS.

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative 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 OKApply your way out.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 07:29:03 -0800, "cameron"
wrote:

When I want to format my numbers in Excel through Format\cell\number\number
the option of choosing negative numbers displayed in brackets "(#,###.##)" is
not available. How do I obtain that option?