View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Displaying -ve numbers

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.

Raj wrote:

How to set default negative number to appear within paranthesis when I
select comma format. I am changing the style to #,###; (#,###) every time
manually


--

Dave Peterson