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.
 

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
Displaying zeros in cells 2
Find Replace Wildcard 9
Find/replace using wild cards to insert space between given characters 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
How to find/replace data in column 4
formula to stop calculating when it comes across a particular valu 3
Simple Find and Replace Question 9

Back
Top