B
bw
In Excel 2007 is it possible to format a minus number with brackets.
Ex: (2013.70)
Ex: (2013.70)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
vdploeg.chris
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
D
Dave Peterson
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.
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.
J
jostlund
This does work in 2007 - thanks very much!
Dave Peterson said: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.
D
Dave Peterson
Thanks for posting back with your results.
This does work in 2007 - thanks very much!