Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Could someone please advise me how I set up a custom number format that makes
negative values appear in brackets eg minus 56000 like this (56,000) rather than -56000. I still want the comma, dollar options on the toolbar to function as they currently do such that if I select $ icon, this number will turn into $56,000.00 or if I want to use the increase/decrease decimal point for say 2 decimal places that my result is (56,000.00) or if I use the comma icon that it defaults to 2 decimal places all with brackets for negative numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you put negative/minus numbers in brackets | Excel Discussion (Misc queries) | |||
Negative numbers in brackets | Excel Discussion (Misc queries) | |||
how do i get negative numbers in brackets in Excel | New Users to Excel | |||
How do I get brackets around negative numbers? | Excel Discussion (Misc queries) | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) |