ISNUMBER Function To Check Numeric Value
DEFINITION:- ISNUMBER Function Is Used To Check The Cell Or A Range Value Is A Number. The ISNUMBER Function Returns True When A Cell Contains A Number, For Text Values, Errors, Or Blanks The ISNUMBER Returns False. You Can Use ISNUMBER To Check That A Cell Contains A Numeric Value, Or The Result Generated By Another Function Or Formula Is A Number Or not.
As Per This Example We Have Numeric Values In Cells A3 To A5 And Text Values In A Cells A6 To A8. After Applying ISNUMBER Function Please Check The Result Below In Image.
NOTE:- Dates And Times Are Considered As Numeric Values, So When You Apply ISNUMBER Function On A Cell It Will Returns True For Them. If Numbers Stored As Text, Then It ISNUMBER Function Will Returns False.