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 are the formulas ?








Put this formula:


Interesting Management