The problem could also because by internal rounding error. There may be a
tiny fraction of a decimal not being seen, and so 0<0, or so it may appear.

Here's an example:
In A1 type the formula
=64.4 - 64
in B1 simply type in .4
in C1 put the formula =IF(A1=B1,"Equal","Not Equal")
The result will be "Not Equal" because the calculation 64.4-64 actually
returned
0.400000000000006 !

If this seems to be the problem, you can try ROUND() or even change the
Excel Options to "Precision as Displayed", just be cautious with that last
one.



"Lake Oswego" wrote:

Excellent work! I did convert that column to text because I was getting
desperate about my Match not working and was trying everything. I have found
several people who have experienced two cells that look and smell the same
but Match won't treat them as the same. We have to be talking about some
hidden formatting that causes Exact to see a difference when we don't.

"T. Valko" wrote:

It sounds like the cells are formatted as TEXT.

Change the format to GENERAL.

Then, select the cell and either double click or hit function key F2 then
hit Enter.

If you have a bunch of cells to convert...

Select all the cells in question
Change the cell format to GENERAL
With the cells still selected
Goto the menu EditReplace
Find what: = (equal sign)
Replace with: = (equal sign)
Replace All

--
Biff
Microsoft Excel MVP


"Lake Oswego" wrote in message
...
Formulas which used to calculate, then disappear leaving only the answer,
now
remain without showing the answer. If I replace = with =, it works but
only
in that case. How can I get back to normal?


.