Data Validation
Posted by Damien on July 29, 2001 10:37 PM
Is there any way to make your workbook with data validation but not with data ranges just data types
e.g only allow numbers entered into a cell but anynumber not one within a parameters
Posted by Dixie on July 29, 2001 11:12 PM
Try this :-
Allow : Decimal
Data : Not Between
Min : 1E-50
Max : 1E-50
Posted by steve w on July 29, 2001 11:13 PM
Try this (lets say you start in cell A1)
in data validation select custom and then use this formula
=isnumber(A1)
then just copy and past to all the cels you want it in,( the formula will change for each cell)
steve w
