Enter only positive numbers

[dalymjl]

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.

 

[Gary''s Student]

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

 

[MartinW]

And another one
Data>Validation>Settings

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


HTH
Martin

 

[Frank Pytel]

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

=abs(a1)

God Bless

Frank Pytel