DataValidation

[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,

 

[Paul Corrado]

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

 

[Syd]

Muhammad:

Thanks for your assistance, I'll give it a whirl!

 

[Syd]

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.


.