I work in large Excel data files where I frequently do a "countif" to compare
account numbers. Sometimes, the "countif" function will result in displaying
the actual formula in the cell, rather than the result. I have tried to make
sure the cells are formatted correctly, etc., but nothing works. Any ideas??