I am trying to force the user to only enter numbers/decimal numbers to cells in excel using data validation custom formula. I tried a range of ways such as using =ISNUMBER(cellID)and =AND(ISNUMBER(A1), A1=TEXT(A1,”General”)).
The issue is that I eiter can’t enter decimals or it allows time to enter which changes the cell format to custom.
What I want is to only allow number and decimal. But seems to be impossible.
Let me know if any one has suggestions.