Replacing 0 with blank

  • Thread starter Thread starter Sandy Ferguson
  • Start date Start date
S

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
 
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
 
From the menu select Tools|Options. Click on the View tab and remove the check against "Zero values". Zeros will now display as
blanks.
 
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.
 
I stand corrected. thanks,

John Green said:
From the menu select Tools|Options. Click on the View tab and remove the
Click to expand...
check against "Zero values". Zeros will now display as
 
Back
Top