MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
then just copy and past to all the cels you want it in,( the formula will change for each cell)

steve w