View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
el zorro[_2_] el zorro[_2_] is offline
external usenet poster
 
Posts: 20
Default DATA Validation (Ignore Blanks)

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.