Enter only positive numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dalymjl - 30 Aug 2007 21:06 GMT

This sounds so stupid but I can't find an answer. How do I force users
to input only positive amounts in a cell. I would like that 0 would
also be an acceptable value but no negative amounts.

Signature

dalymjl

Reply to this Message

Gary''s Student - 31 Aug 2007 02:32 GMT

Data > Validation... > Settings > Allow > Custom > Formula
=A1>=0

Signature

Gary''s Student - gsnu200741

> This sounds so stupid but I can't find an answer. How do I force users
> to input only positive amounts in a cell. I would like that 0 would
> also be an acceptable value but no negative amounts.

Reply to this Message

MartinW - 31 Aug 2007 10:51 GMT

And another one
Data>Validation>Settings

Allow:
Decimal
Data:
Greater than or equal to
Minimum:
0

HTH
Martin

> This sounds so stupid but I can't find an answer. How do I force users
> to input only positive amounts in a cell. I would like that 0 would
> also be an acceptable value but no negative amounts.

Reply to this Message

Frank Pytel - 01 Sep 2007 23:20 GMT

You could create a dummy entry form and then reference that cell on your calc
sheet with;

=abs(a1)

God Bless

Frank Pytel

> This sounds so stupid but I can't find an answer. How do I force users
> to input only positive amounts in a cell. I would like that 0 would
> also be an acceptable value but no negative amounts.

Reply to this Message