find
 

I'm trying to find all the 0's in a certain column and replace them
with a blank. However, when I hit the "find next" it finds a number
that's not 0. For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all. I don't what the problem is.

find
 

One way you could achieve this is to highlight the column and then
apply conditional formatting - Format | Conditional Formatting and in
the panel that pops up set the condition as Cell Content Is, Equal To,
0 (zero) then click the Format button, and select the colour as White,
then OK twice. This will use a white foreground colour on a white
background for cells that contain 0, which will make them appear
blank.

Hope this helps.

Pete

On Jul 10, 8:56 pm, LLama wrote:
I'm trying to find all the 0's in a certain column and replace them
with a blank. However, when I hit the "find next" it finds a number
that's not 0. For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all. I don't what the problem is.

find
 

Select the column by clicking on the letter above that column.

Then hit Ctrl-H or go to the Edit menu and select Replace (this will bring
up the Find and Replace command)

now put 0 in the Find box and key in a space for an actual character of
space or key nothing for a null value.



"LLama" wrote:

I'm trying to find all the 0's in a certain column and replace them
with a blank. However, when I hit the "find next" it finds a number
that's not 0. For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all. I don't what the problem is.

find
 

Maybe I'm wrong, but I don't think that will help. Won't the number 0
still be in the cell, I just won't be able to see it?



On Jul 10, 4:12 pm, Pete_UK wrote:
One way you could achieve this is to highlight the column and then
apply conditional formatting - Format | Conditional Formatting and in
the panel that pops up set the condition as Cell Content Is, Equal To,
0 (zero) then click the Format button, and select the colour as White,
then OK twice. This will use a white foreground colour on a white
background for cells that contain 0, which will make them appear
blank.

Hope this helps.

Pete

On Jul 10, 8:56 pm, LLama wrote:

I'm trying to find all the 0's in a certain column and replace them
with a blank. However, when I hit the "find next" it finds a number
that's not 0. For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all. I don't what the problem is.