Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Stone Ridge, New York, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding 0's in Calc Formula Field (Word 2000)

    Hi,

    Is there a way to hide the 0's in a Formula field until a calculation is actually done. For example, if I have an invoice with 10 rows and each row calculates the # of Items x Cost Per Item - I don't want the $0.00 to appear in the Total cell unless the row is being used. I don't want a column full of $0.00's. Anyway to get rid of those? This is a protected form.

    Thanks in advance.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Hiding 0's in Calc Formula Field (Word 2000)

    You might be able to do this with the IF field, leaving a blank string if the result is 0:

    { IF <your calculation field>=0 "" "<your calculation field>" }

    At least it's worth a try. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Hiding 0's in Calc Formula Field (Word 2000)

    Hi Sherry,

    To hide zero values in a word formula, use a numeric picture switch like:
    # $,#.00;$-,#.00;
    The last semi-colon tells Word to hide the zero value. The $,#.00 tells Word to display +ve $ values to two decimal places (change this to suit), and the -$,#.00 tells Word to display -ve $ values to two decimal places (change this to suit also). As well, if you want -ve values to display in red, simply colour the font for <font color=red>-$,#.00</font color=red> in red.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •