Data Validation
Thanks Martin
"Martin Brown" wrote:
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
.
|