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

steve w