Replacing 0 with blank

[Sandy Ferguson]

I have a number of worksheets with many 0 cells. I wish to replace the
0 cells with blank. If I use replace 0 with blank it also changes the
10,20 etc to 1,2 by removing the 0. I have tried searching for 0 with
a leading blank, using various functions & just about run out of
ideas. I am NOT an Excel expert & would appreciate any help

 

[JON JON]

Sandy,

You are already on the right track. When you use the "Find and Replace"
before you click the replace (or replace all) button look for the button
with labeled as "option>>". Then look for a "match case" click the square
before it.

Hope this will help!

Jon-jon

 

[John Green]

From the menu select Tools|Options. Click on the View tab and remove the check against "Zero values". Zeros will now display as
blanks.

 

[Dave Peterson]

I think Jon Jon meant to write:

Look under options for "match entire cell contents"

And check that.

And I'd suggest that you not replace the 0 with a blank (" "), but leave that
"Replace with" box empty. It'll be like clicking on the cell and hitting the
delete key.

 

[JON JON]

I stand corrected. thanks,

From the menu select Tools|Options. Click on the View tab and remove the

check against "Zero values". Zeros will now display as