Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2007 is it possible to format a minus number with brackets.
Ex: (2013.70) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Jul 6, 1:08 pm, bw wrote:
In Excel 2007 is it possible to format a minus number with brackets. Ex: (2013.70) Right click the cell(s) to format. Select format cells... select number under category then I think that it is the 3rd and 4th option depending on the colours that you want |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could give it a custom format:
General;(General);0;@ (positive; negative; zero; text ==== If you want to be able to see those ()'s when you're in the format|number tab|number category, you could try this (it works in xl2003--I didn't test it in xl2007). 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. bw wrote: In Excel 2007 is it possible to format a minus number with brackets. Ex: (2013.70) -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This does work in 2007 - thanks very much!
"Dave Peterson" wrote: You could give it a custom format: General;(General);0;@ (positive; negative; zero; text ==== If you want to be able to see those ()'s when you're in the format|number tab|number category, you could try this (it works in xl2003--I didn't test it in xl2007). 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. bw wrote: In Excel 2007 is it possible to format a minus number with brackets. Ex: (2013.70) -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for posting back with your results.
jostlund wrote: This does work in 2007 - thanks very much! "Dave Peterson" wrote: You could give it a custom format: General;(General);0;@ (positive; negative; zero; text ==== If you want to be able to see those ()'s when you're in the format|number tab|number category, you could try this (it works in xl2003--I didn't test it in xl2007). 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. bw wrote: In Excel 2007 is it possible to format a minus number with brackets. Ex: (2013.70) -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |