Solved
Identify cells with numerical values even tho formatting is non-numeric in Excel
Posted on 2011-02-27
Hello,
In Excel (2007), suppose a cell has some numerical value (e.g. 1858) but the cell formatting is set to General (i.e. not Number), is there a way -- using =ISNUMBER() or some other function -- to determine that the value is numerical?
In a broader sense, can a cell, regardless of it's formatting, which has only digits (0-9) and no other characters or symbols (except a period if it involves decimal places), be distinguished from cells which do not meet those criteria?
Thanks
f a cell