Thread: Formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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