Data Validation - Blank Cell

O

Otto Moehrbach

Excel 2002, WinXP
I have a cell in which I want to restrict the entry.
I want a whole number greater than zero.
I do not want a blank cell.

I do Data Validation
I select Whole Number
I select "Greater than or equal to"
I enter a 1.
I uncheck the "Ignore Blank" box.
All works well except that I can clear the cell (hit Delete key) and I get
no error message.
What am I doing wrong?
Thanks for your help. Otto
 
F

Frank Kabel

Hi
you're not doing anything wrong. No way to prevent the DEL key with
'Data - Validation' (another drawback is that you can copy/paste values
in this cell).
 
Top