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?


.