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.

DATA Validation (Ignore Blanks)
 

How do you enter a blank? I assume you means a space? If that's the case use

=AND(A1=0,ISNUMBER(A1))


--
Regards,

Peo Sjoblom



"el zorro" wrote in message
...
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.

DATA Validation (Ignore Blanks)
 

Peo,

It's working halfway. The formula works for space, but not for blank.

When a valid number is entered, "Deleted" and then hit the return key, cell
A1 is back to "blank".

Do you have another solution? Thanks in advance.


"Peo Sjoblom" wrote:

How do you enter a blank? I assume you means a space? If that's the case use

=AND(A1=0,ISNUMBER(A1))


--
Regards,

Peo Sjoblom



"el zorro" wrote in message
...
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.

DATA Validation (Ignore Blanks)
 

You don't enter a blank, you clear the cell of it's content
There is no data validation that will stop you from clearing the contents of
a cell
That would take an event macro but of course macros can be bypassed when you
open the workbook. You can't really "idiot proof" a workbook

--
Regards,

Peo Sjoblom


"el zorro" wrote in message
...
Peo,

It's working halfway. The formula works for space, but not for blank.

When a valid number is entered, "Deleted" and then hit the return key,
cell
A1 is back to "blank".

Do you have another solution? Thanks in advance.


"Peo Sjoblom" wrote:

How do you enter a blank? I assume you means a space? If that's the case
use

=AND(A1=0,ISNUMBER(A1))


--
Regards,

Peo Sjoblom



"el zorro" wrote in message
...
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.