I have Excel 2003, and for some odd reason, when I try to format cells to
negative numbers with brackets, the option I would normal choose shows
negative signs.

Has anyone else seen this before?

Thanks,

Without knowing what option you would "normal choose", I'd recommend:

Format/Cells/Number/Custom 0.00_);[0.00];0.00_)


In article ,
T Standish <T wrote:

I have Excel 2003, and for some odd reason, when I try to format cells to
negative numbers with brackets, the option I would normal choose shows
negative signs.

Has anyone else seen this before?

Thanks,

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 Mon, 15 Oct 2007 15:24:02 -0700, T Standish <T
wrote:

I have Excel 2003, and for some odd reason, when I try to format cells to
negative numbers with brackets, the option I would normal choose shows
negative signs.

Has anyone else seen this before?

Thanks,