Explanation

Data validation rules are triggered when a user adds or changes a cell value.

The ISNUMBER function returns TRUE when a value is numeric and FALSE if not.

As a result, all numeric input will pass validation.

Excel formula: Data validation allow text only

Be aware that numeric input includes dates and times, whole numbers, and decimal values.

Excel formula: Data validation only dates between

Excel ISNUMBER function