Required Numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting RIC1 code to letter Column/Numeric Row 5
converting text cell to numeric cell 5
Summing rows using formulas with variables 1
Assign numerical value to cell based on selection from drop-down m 1
Alpha to Numeral column name 3
Average value only for the filtered area.. 4
Copying formula results into cells with numerical formats 1
Copying Numeric Text 4

Back
Top