Limit data entry to 1/4" increments
 

I have a need to create a input sheet that only lets the user input
numbers in 1/4" increments like
33.00
33.25
33.50
33.75
50.25
22.75

NO 33.125 or 43.375 numbers.
Is there some way with data validation or other way? I tried cell
formating but it only displays it as a fraction. I want it to reject a
entry that does not equal a number on the quarter inch increment.

Thanks
Scott

Limit data entry to 1/4" increments
 

Use Data ValidationAllowCustomFormula:

=MOD(A1,0.25)=0

--
Biff
Microsoft Excel MVP


wrote in message
...
I have a need to create a input sheet that only lets the user input
numbers in 1/4" increments like
33.00
33.25
33.50
33.75
50.25
22.75

NO 33.125 or 43.375 numbers.
Is there some way with data validation or other way? I tried cell
formating but it only displays it as a fraction. I want it to reject a
entry that does not equal a number on the quarter inch increment.

Thanks
Scott