Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Numbers in Brackets | Excel Discussion (Misc queries) | |||
Negative numbers in brackets | Excel Discussion (Misc queries) | |||
negative numbers as brackets an Excel option | Excel Discussion (Misc queries) | |||
How do I get brackets around negative numbers? | Excel Discussion (Misc queries) | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) |