Isnumber always returns false
=ISNUMBER(cell) keeps keeps returning FALSE even though there is a number in the cell. This only happens when the number in the cell is the result of a formula. The formatting is set to number for all cells involved and there are no errors in the formula or formulas in the cells it references . If I delete the formula in the cell and retype the same number, =ISNUMBER returns TRUE. This happens with any cell that has a formula and and number result in it. No setting or format changes I have tried seem to help. Any ideas?
This statement seems to contain a common misunderstanding. Formatting does not change data type stored in a cell. If it is stored as text at some point in time, you need to perform an explicit type conversion - formatting cannot cure that. Example: If you format a cell as Textbefore you enter data, you'll get Text-type values into your cell, even if you enter
12345
.Another problem might be that there a functions, which work with text strings and perform an implicit type conversion (e.g.
REGEX()
,CONCAT()
....). What I try to say: You did not provide any of the formulas in use, thus nobody will be able to correctly analyze your specific issue.