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
|