find/replace

  • 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.
 
LLama

Is 126.423 the result of a formula?
If you select the cell that contains 126.423,
what does the Formula bar display?

George Gee
 
Hi

In the Find and Replace dialogue, click Options and tick Match entire
cell contents.
 
Back
Top