Replacing 0 with blank
 

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

Replacing 0 with blank
 

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

"Sandy Ferguson" wrote in message
m...
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

Replacing 0 with blank
 

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



--

John Green - Excel MVP
Sydney
Australia


"Sandy Ferguson" wrote in message m...
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

Replacing 0 with blank
 

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 wrote:

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

"Sandy Ferguson" wrote in message
m...
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

--

Dave Peterson

Replacing 0 with blank
 

I stand corrected. thanks,

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



--

John Green - Excel MVP
Sydney
Australia


"Sandy Ferguson" wrote in message
m...
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