Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Showing zeros (Office XP)

    Hey all,

    Can anyone tell me if it is possible to have ZERO VALUES unchecked (do not show zeros) in TOOLS, OPTOINS, VIEW tab and still have zero value show in one specific cell?

    I have ZERO VALUES unchecked so that all the zero values on my invoice template don't show. However, if a customer has paid for an order in advance then the TOTAL DUE cell remains blank instead of showing a balance due of "$0.00.

    I suppose I could solve this by adding an IF statement to each line items " total cell" that leaves the cell blank if there is no value in the adjoing "cost each" cell, but altering just the total cell would be earier if I could do so.

    Thanks,
    BH Davis

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Showing zeros (Office XP)

    You can set a custom number format for this cell, for example
    <code>
    $ 0.00_-;$ 0.00-;"0.00"_-
    </code>
    The first part is for positive values, the second part for negative values and the third part for zero values. The quotes tell Excel that it's a literal text.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Showing zeros (Office XP)

    HansV,

    WOW!!!!! That's great. I tried changing the "negative" balance to parenthases, that is, ($10.00) for a negative balance of $10.00, and that worked also.

    As always your knowledge and wisdom are greatly appreicated! !!

    BH

Posting Permissions

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