find/replace
 

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/replace
 

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


"LLama" wrote in message
ups.com...
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/replace
 

Hi

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

--
Regards

Roger Govier


"LLama" wrote in message
ups.com...
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.