LaDdIe wrote:
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.

You can set validation to whole number and a specific range, but you
cannot prevent the user pressing return on an empty cell. You would have
to move the test for ISNUMBER() into whatever the next stage is.

NB A blank cell looks to some Excel numeric functions like zero.

Regards,
Martin Brown