View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheila D
 
Posts: n/a
Default negative numbers as brackets an Excel option

You need to look at the option for Custom formatting which allows you to
specify how you want Positive, Negative etc figures displayed. You should be
able to find something close to the format you need and then change it as
required. HTH
"cameron" wrote:

When I want to format my numbers in Excel through Format\cell\number\number
the option of choosing negative numbers displayed in brackets "(#,###.##)" is
not available. How do I obtain that option?