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 Negative figures in brackets

If you just want that format (with the ()'s) to show up in the samples in
format|Cells|Number tab...

Excel picks this up from a windows setting:

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.

IoHeFy wrote:

Hello,

I'm hoping this should be easily fixed? Basically I just need to know how
(if?) you can get negative numbers to appear in brackets, rather than having
a minus '-' sign in front of the figure.

Thanks


--

Dave Peterson