Required Numeric

R

RTP

Is there any way with a formula to make sure a cell is numeric and to post an
error message if it is NOT numeric???
 
T

Ted Metro

Click on your cell and then go to the 'Data' tab at the top menu and click on
Validation. You can then select 'decimal' for what's allowed and allow
anything between -99999999999 and 99999999999. If someone enters letters
instead of numbers it will provide an error message, which you can specify
under the 'Error Alert' tab on that validation area.

TM
 
A

Art

Try IsNumber(). It returns a true or false. You can put this inside an if
to produce other messages, for example: =if(isnumber(A2),"","OOPS").

Alternatively you can use a conditional format within the cell you're
testing to change the format (like background color) if it's non numeric.

To do this, go to conditional format, select "formula is", and type:
= NOT(ISNUMBER(A2))
And then select your format

Art
 
B

Bernard Liengme

Use Format | Conditional Formatting
Set Formula to =NOT(ISNUMBER(A1)) ---- change reference to suit need
And make font and/or pattern to colour (red?)

best wishes
 
Top