Do not allow negative numbers in cell
Hey-
I found it. Select custom and if I am validating C3 the formula needs to be
=and(c3<0,isnumber(c3))
--
JNW
"JNW" wrote:
How can I restrict entry of positive numbers in a cell using data validation?
In other words I want only to be able to enter numbers that are less than 0.
Thanks.
--
JNW
|