Hi

I had a column that I totalled using SUM function and it returned a value. I noticed the value was somewhat short of what I knew the total should be.
Inspecting the values in the column i noticed one cell looked different. The cell didn't contain an apostrophe.
I used ISTEXT function on the cell and it returned TRUE.
I then used clear all to remove the contents and format of the cell and keyed the value in again and all was resolved.
In Options - Formulas, Error checking rules - Numbers formatted as text or preceded by an apostrophe is checked.

I'd like to know is there a way that Excel can visually indicate if a cell contains a text value in a cell. This could of so easily of been missed.

Any help greatly appreciated.

Kenneth