data validation and null text

[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.

 

[Bob Phillips]

Uncheck the ignore blank checkbox as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[JE McGimpsey]

Did you uncheck the "Ignore Blank" checkbox in the Validation dialog?

 

[Scarababau]

Uncheck the ignore blank checkbox as well.

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