Check if the cell contains only numbers with a formula in an excel report

This formula helped me to identify which cells are only numbers so if a cell contains a mix of letters and numbers, it will show me “no”. In fact, I combined this formula with another one to get the wanted result but here, I am just showing the basic function.

macro excel

 

When I use the formula ?

To check if the cells are only numbers.

 

How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".

 

How is/are the formula(s) ?

=IF()

=SUMPRODUCT()

=ISNUMBER()

=MID()

=ROW()

=INDIRECT()

=LEN()

Put this formula:

=IF(SUMPRODUCT(--ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)))=LEN(A2),"yes","no")

Interesting Topics