Validate to quarter units
On Thu, 25 Feb 2010 10:49:01 -0800, 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.
Data/Validation/Settings
Custom
Formula: =MOD(A1,0.25)=0
--ron
|