Option to put brackets around negative numbers not available in 20
 

Although I have set up the defauilt in the Control Panel to make negative
numbers use brackets rather than the minus sign, in Excel 2003 under 'Format
Cells Number, there is no option for brackets at all. It used to work before
we had the software re-installed on new servers. Where might this setting be?

Option to put brackets around negative numbers not available in 20
 

Hi,

1) In format, instead of number, select custom & paste the line below.

#,##0;[Red](#,##0)

All negative numbers will be displayed in red & will have bracket around them
HTH,
--
Tausif Mohammed


"Patricia" wrote:

Although I have set up the defauilt in the Control Panel to make negative
numbers use brackets rather than the minus sign, in Excel 2003 under 'Format
Cells Number, there is no option for brackets at all. It used to work before
we had the software re-installed on new servers. Where might this setting be?

Option to put brackets around negative numbers not available i
 

Hi

Thanks for your answer, but I'm trying to find out why the option has
disappeared in the first place - and where the setting to change it back
might be, if anyone has any ideas?
Thanks

"Tausif" wrote:

Hi,

1) In format, instead of number, select custom & paste the line below.

#,##0;[Red](#,##0)

All negative numbers will be displayed in red & will have bracket around them
HTH,
--
Tausif Mohammed


"Patricia" wrote:

Although I have set up the defauilt in the Control Panel to make negative
numbers use brackets rather than the minus sign, in Excel 2003 under 'Format
Cells Number, there is no option for brackets at all. It used to work before
we had the software re-installed on new servers. Where might this setting be?

Option to put brackets around negative numbers not available in 20
 

The setting is under "Currency" in Control Panel Regional and Language
OptionsCustomize

I know logically it should be under Numbers but is not.


Gord Dibben MS Excel MVP

On Fri, 8 Aug 2008 02:48:01 -0700, Patricia
wrote:

Although I have set up the defauilt in the Control Panel to make negative
numbers use brackets rather than the minus sign, in Excel 2003 under 'Format
Cells Number, there is no option for brackets at all. It used to work before
we had the software re-installed on new servers. Where might this setting be?