data validation and null text

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.

Uncheck the ignore blank checkbox as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scarababau" <scarabeo@mailinator.com> wrote in message
news:1143794739.937316.163040@u72g2000cwu.googlegroups.com...
> 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.
>

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

In article <1143794739.937316.163040@u72g2000cwu.googlegroups.com>,
"Scarababau" <scarabeo@mailinator.com> wrote:

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

> Uncheck the ignore blank checkbox as well.

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