Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you put negative/minus numbers in brackets
Hello,
How do you get minus/negative numbers to appear in brackets? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you put negative/minus numbers in brackets
You can set custom to #;"("#")";#
But there is an easier way - can't find it though Steve On Wed, 25 Oct 2006 11:51:03 +0100, IoHeFy wrote: Hello, How do you get minus/negative numbers to appear in brackets? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you put negative/minus numbers in brackets
In the Format Cells dialog, with "Number" selected the third "negative
numbers" option shows parens (or brackets as they say in England, etc.). If you do not see a bracketed format there you have to change your negative number format for CURRENCY (not Numbers) under Windows Control Panel, Regional Settings to use parens. -- Jim "IoHeFy" wrote in message ... | Hello, | | How do you get minus/negative numbers to appear in brackets? | | Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this possible ??? | Excel Discussion (Misc queries) | |||
Brackets or paranthesis around negative numbers in Excel | New Users to Excel | |||
Brackets or paranthesis around negative numbers in Excel | New Users to Excel | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
How do I get brackets around negative numbers? | Excel Discussion (Misc queries) |