data validation and null text

S

Scarababau

Is there a method (no macro) to prevent that when editing a cell it
cannot contains a null (blank) text?
I have tried with cell A1 inserting the following formula in Data
validation: "=(LEN(A1)>0)" but it does not work.
 
B

Bob Phillips

Uncheck the ignore blank checkbox as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
S

Scarababau

Uncheck the ignore blank checkbox as well.

Unchecked, but it does not work the same...
 
Top