# 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

notchange 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 asTextbeforeyou enter data, you'll getText-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.