find

  • Thread starter Thread starter LLama
  • Start date Start date
L

LLama

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.
 
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
 
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.
 
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?
 
Back
Top