I don't think Data Validation is going to do that. What is the driver that
is going to force the user to do anything? In other words, what do you want
to happen if the user doesn't follow your rules?
An example of what can happen: If the user doesn't follow the rules, and
attempts to close or save the file, a message box will pop up saying
whatever you want it to, and the file will nor close or save. The driver,
in this instance, is that he can't close or save the file if he doesn't
follow your rules. So the question is back to you; what do you want to
happen if the user doesn't follow your rules? HTH Otto

"LaDdIe" wrote in message
...
Hi,

I'm trying to apply data validation to a range of cells, the rules are
that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.