Thank you! Perfect. All set.
Dean



colofnature wrote:
In the validation criteria, select Custom from the Allow list, and
enter

=MOD(A1,50)=0

in the Formula box (change A1 to whichever cell you're putting the
validation on). If a user tries to enter a value which isn't a multiple
of 50 they'll get an error.

Hope that helps
Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=558426