Excel Spreadsheet question?

Question

I am trying to empty out cells that have a single zero in them, when I run a search it picks out every zero whether the number 2002 or just 0.  Is there anyway to "zero" in on the single zero cells and remove the information from the cell ... also if 0 is the answer to a formula I don't want to lose that.

WhatsYourProblem · Accepted Answer

Without seeing the spreadsheet:

Use autofilter, select custom. then select "Equals" 0

If you need to unmerge all the cells, hit ctrl + A to select the entire sheet. Then go to Format --> Cells, select the alignment tab and uncheck the box that says "Merge Cells"

aladou · Answer

This should be an easy one.

- If you're not doing this on the entire sheet/tab, then select the data where you want to empty them out
- Edit - Replace
- Find what: put 0
- Replace with: leave blank
- Click Options to expand this dialog box
- Check the box for Match entire cell contents
- Replace All

This will only remove the 0s from those cells which only have a zero.
Good luck.
.

clinky · Answer

Are the cells with zeros in the result of a formula? if so you may need to add this to all problem zero cells:

=if(d1="", "" , sum(D1:d5)) this may solve the problem. the =if(d1="", "" part means if D1 is null/empty then the reulting cell is zero, otherwise you will have a zero or error.

Chetu · Answer

you don't want zeros but you also don,t want to lose formula.

here is one think you can try,
put your formula in if fucation 
i.e =IF(((A1+B1+C1)=0)," ",(A1+B1+C1))
this formula will display result if total of a1+b1+c1 is more then 0 and if it is 0 then it wont show 0 in your cell

Anonymous · Answer

is this all in one column?  or thoughout all the columns?

Excel Spreadsheet question?

Related Questions

Trending Questions