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
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
