View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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