Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
JR JR is offline
external usenet poster
 
Posts: 29
Default parenthesis for negative numbers

how do I get the negative numbers to appear in parens instead of the negative
sign in front of it?
  #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.


  #3   Report Post  
Posted to microsoft.public.word.tables
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default parenthesis for negative numbers

Delete the minus sign and press Shift+9 before the number and Shift+0 after
the number.

Or... did you mean automatically? If you mean automatically, Word does not
have the ability to format numbers in that way--for that, you could use
Excel. One way would be to embed an Excel worksheet inside Word to use as
the basis for your table. That way you would have all of Excel's
capabilities when editing and formatting the table.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


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


  #4   Report Post  
Posted to microsoft.public.word.tables
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default parenthesis for negative numbers

I said:

Or... did you mean automatically? If you mean automatically, Word does not
have the ability to format numbers in that way...


Except using field codes, as Jay points out. However, unless you're already
using a field, enshrining your numbers in a { = } field seems like a lot
more work than just adding your own parentheses. It could also be done using
Find/Replace--with or without difficulty depending on whether the numbers
contains commas. Assuming they don't and numbers don't have more than 10
digits, select the table, row, or column of interest, and use:

Find what:-([0-9]{1,10}) (and enable Use wildcards)
Replace with\1)

Add the desired currency symbol as needed if you're dealing with money.

You could commit the Find/Replace to a macro and assign it to a
key/button/etc. so that you could simply apply it to a table that's
populated with numbers that need to be ()'ed.

If the numbers contain commas, a more complex specification might be able to
find them, but it's probably not worth the brain strain unless they do.

All in all... I'd use an Excel table if I needed (9) instead of -9 and had a
lot of instances.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Herb Tyson [MVP]" wrote in message
...
Delete the minus sign and press Shift+9 before the number and Shift+0
after the number.

Or... did you mean automatically? If you mean automatically, Word does not
have the ability to format numbers in that way--for that, you could use
Excel. One way would be to embed an Excel worksheet inside Word to use as
the basis for your table. That way you would have all of Excel's
capabilities when editing and formatting the table.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting negative numbers JCFFinance New Users 1 October 2nd 08 05:35 AM
how do I create negative numbers in Equation editor in.jester New Users 2 July 11th 07 02:17 AM
How to format negative numbers in Word tables Warrain Tables 9 March 17th 06 04:41 PM
How do I set up calculation fields in Word with negative numbers? Spacie Microsoft Word Help 1 August 18th 05 05:18 AM
Negative numbers at end of line Ruth Levinson Microsoft Word Help 10 February 28th 05 10:13 PM


All times are GMT +1. The time now is 06:45 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"