View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default parenthesis for negative numbers

jr wrote:
how do I get the negative numbers to appear in parens instead of the
negative sign in front of it?


Use a numeric picture switch in the formula or sum field, as shown in
http://www.gmayor.com/formatting_wor...m#basic_switch.

For example, if the numbers in the table column are decimals with two
digits, the field would look like

{ =SUM(ABOVE) \#"0.00; (0.00)" }


--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.