Hi Shawn,

Not sure of the interpretation of your question. Do you mean that all values
must be less than one be in quarter increments or that the values can include
greater than one but must be in quarter increments.

Use Data validation. Select the range to be validated and enter the formula
as if it applies to the first cell of the selected range. (Excel looks after
applying it correctly to the remaining cells in the selection.)

If the first option above then the following in Data Validation formula.
=AND(MOD(A1,0.25)=0,A1<1)

If the second option then the following Data Validation formula.
=MOD(A1,0.25)=0

--
Regards,

OssieMac


"Shawn" wrote:

Is there a way to have the cells validate to quarter units? Specifically, I
only want users to be able to enter .00; .25; .50; or .75 numbers.
--
Thanks
Shawn