DataValidation

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

Is there a way to test for an is numeric value in a cell?
If the data is not a number/numeric inform the user to re-
enter the value as a number?

Thanks,
 
Data/Validation

Select Custom and use

=ISNUMBER(A1)

Where A1 is the active cell in the range you select

You can use the Input Message and Error Alert to provide the necessary
information to users.

HTH

PC
 
Anon:

Thanks for help.....

-----Original Message-----


You want Validation on the Data menu.

Select the cell you want to validate (say A1).
Data > Validation.
In the Allow box select Custom.
In the formula box type the formula
=ISNUMBER(A1)
(replacing A1 in this with your actual cell reference).
If you want a particular warning message, use the Input Message tab.


.
Click to expand...
 
Back
Top