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
|