G
Guest
I have a cell A1 which needs to be populated with a number of 0 or greater
and it cannot be left blank.
I used DATA validation with the "Custom" option and populated the "Formula"
with =A1>=0.
I also unclicked the Ignore Blank.
Somehow the validation works for zero or greater but I can still enter
"blank".
Where have I gone in err?
Thanks.
and it cannot be left blank.
I used DATA validation with the "Custom" option and populated the "Formula"
with =A1>=0.
I also unclicked the Ignore Blank.
Somehow the validation works for zero or greater but I can still enter
"blank".
Where have I gone in err?
Thanks.