How to delet the 0 values but leave the zero place holders?

**Dshaw2** · 08-09-2012, 03:03 PM

I have a sheet that is much bigger than this one but this is an example of what it looks like. I need to delete the zeros if the value of the cell is zero but keep the zeroes that hold a place like in the number 10. How do I do it? I don't want to hide the 0 I need to delete it so they won't be factored into min calculations. Thanks for your help.

40 40 42 45
37 37 39
0 0 0 0
0 0 0 0
41 42 43 0
0 0 0 0
0 0 0 0
35 35 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
37 38 40 0
0 0 0 0
41 40 40 40
41 0 0 0
0 0 0 0
50 50 55 60
0 0 0 0
38 42 45 0
38 35 38 40
0 0 0 0
39 39 40 43
0 38 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

**BenMiller** · 08-09-2012, 03:12 PM

Do a find replace (CTRL+H) and type 0 and leave the Replace With field empty. Make sure to check "Match entire cell contents"

**Dshaw2** · 08-10-2012, 10:56 AM

That worked beautifully! It was the "match entire cell contents" that really made the difference. Thanks

**BenMiller** · 08-10-2012, 11:16 AM

No problem

Glad I could help ... Appreciate the feedback!

**jeffreybrown** · 08-10-2012, 11:18 AM

Hi Dshaw2 & Welcome to the Forum,

If you are satisfied with the solution(s) provided, please don't forget to mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save