Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Liliana Hartwig Liliana Hartwig is offline
external usenet poster
 
Posts: 1
Default display negative numbers in a table in brackets

I have a table in word which displays negative number with the "-" symbol,
I'd like to use brackets instead.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default display negative numbers in a table in brackets

Hi Liliana,

If the -ve value is the result of a formula field calculation, you can add a numeric picture switch to it to control the dsiplay
format. To do this:
.. select the field (not the whole cell) and press Shift-F9 to display the field code. It should look something like {=SUM(ABOVE)} or
{=SUM(A1:A5} or {=A1+A2}, depending on the kind of formula it's using. If you see {FORMTEXT}, it's a formfield, for which you can
change the display format by right-clicking and choosing 'Properties'.
.. for anything other than a formfield, edit the field by adding '\# $,0.00;($,0.00)', so that you get something like {=SUM(ABOVE) \#
$,0.00;($,0.00)} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;

Other formula field formatting possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values

The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.


--
Cheers
macropod
[Microsoft MVP - Word]


"Liliana Hartwig" Liliana wrote in message
...
I have a table in word which displays negative number with the "-" symbol,
I'd like to use brackets instead.


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
Display Negative Value as Positive Martha Mailmerge 3 November 17th 07 08:40 PM
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
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 03:20 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"