View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dav
 
Posts: n/a
Default Brackets or paranthesis around negative numbers in Excel


No,

But it is very easy to create, go to the custom category under number
tab when u format cells. Create your own format

#,##0;(#,##0) if you just want brackets

#,##0;-(#,##0) if you want a minus outside the brackets

#,##0;(-#,##0) if you want a minus inside the brackets

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=506743