find/replace

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.
 
G

George Gee

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
 
R

Roger Govier

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find 3
Find Replace Wildcard 9
Displaying zeros in cells 2
Simple Find and Replace Question 9
How to find/replace data in column 4
Run select query from VBA code where criteria comes from a multi select ListBox 2
Find/Replace Question 3
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1

Top