Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in brackets
I cannot find an option for showing negative numbers in brackets when I go to
Format, cell, number. The only choices I find are either to show with minus sign or in red. Any suggestions would be welcome. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in brackets
Try something like:
Format Cells... Number Custom General;(General);General;@ -- Gary's Student "Keith" wrote: I cannot find an option for showing negative numbers in brackets when I go to Format, cell, number. The only choices I find are either to show with minus sign or in red. Any suggestions would be welcome. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in brackets
Excel picks this up from a windows setting:
Windows start button|control panel regional and language options regional options tab click the customize button currency tab change the negative currency format to show ()'s. Keith wrote: I cannot find an option for showing negative numbers in brackets when I go to Format, cell, number. The only choices I find are either to show with minus sign or in red. Any suggestions would be welcome. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in brackets
Keith
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 Sun, 24 Sep 2006 08:21:01 -0700, Keith wrote: I cannot find an option for showing negative numbers in brackets when I go to Format, cell, number. The only choices I find are either to show with minus sign or in red. Any suggestions would be welcome. Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in brackets
And just to clarify one point - it's parentheses, not brackets.
( ) are parentheses; [ ] are brackets; { } are braces |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
how do i use excel's natural log function with negative numbers? | Excel Worksheet Functions | |||
Brackets or paranthesis around negative numbers in Excel | New Users to Excel | |||
Changing negative numbers to zero | Excel Discussion (Misc queries) | |||
Negative Numbers | Excel Discussion (Misc queries) |