| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
In Excel 2007 is it possible to format a minus number with brackets.
Ex: (2013.70) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting
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
|
|||
|
|||
|
Formatting
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
|
|||
|
|||
|
Formatting
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
|
|||
|
|||
|
Formatting
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
