Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: removing zero values

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi, i have a shopping basket on my project and when people add purchases to the basket, it adds all of the purchases on the page, even if the quantity is zero, is there any way to remove all the items with zero on them before the contents of the basket is added to the invoice?

    BoB

    p.s the zero values have 2 other cells related to them and these are located to the immediate left of the cells with the zero values in them, and i need these to be removed aswell

    [ This Message was edited by: canablitz on 2002-04-10 01:12 ]

    [ This Message was edited by: canablitz on 2002-04-10 01:22 ]

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tools|Options|View|Uncheck "Zero Values"
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Bob

    Not sure if you want them removed or just hidden, but to remove try, Edit>Replace then type a "0" in the "Find What:" box, leave the "Replace With:" box empty.

    *VERY IMPORTANT: Make sure you check the "Match Case" AND the "Find entire Cells Only" Options.



    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training


    [ This Message was edited by: Dave Hawley on 2002-04-09 07:23 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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