Results 1 to 4 of 4
  1. #1
    dmcminds
    Guest

    Find and Replace Zeros

    How do I replace 0's with blanks only in cells with just 0's? Every time I try it changes 10 to 1, etc.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find and Replace Zeros

    You don't have to physically remove the zeroes with a find and replace- there's several other ways (custom formatting, using a formula, using colours)

    Have a look at this thread- there should be something in there to help.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    dmcminds
    Guest

    Re: Find and Replace Zeros

    Thank you very much!

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find and Replace Zeros

    If you have zeroes that were actually entered into the cell and you want to replace them with nothing, then you can do that with Replace from the Edit menu. In the Replace dialog box, enter a zero in the Find what box and nothing in the replace with box. At the bottom of the dialog box there is a check box labeled "Find entier cell". CHeck that check box and press the "Replace" or "Replace all" button. This should replace all 0s but not 10, 100, 00, etc.

    If the zero is displaying as the result of a formula in the cell, then this will not work. You will have to use one of the methods in the thread that Geoff pointed you to.
    Legare Coleman

Posting Permissions

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