The =ISNUMBER() function in Excel checks if a cell contains a numeric value or not, it returns either TRUE or FALSE.
The function only requires one argument, the value that you want to test.
Below we have some input in column B – in column C we want the result.
Enter the following formula in cell C4:
=ISNUMBER(B4)
123 is a numerical value – so we get TRUE in C4. Drag the formula down to fill the rest of the rows.
Pay careful attention to B6, depening on the format of the date and your settings – this can deliver different result.
2025-01-01 on my system returns TRUE
Excel tutorials 
Leave a comment