Enter only positive numbers
 

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.

Enter only positive numbers
 

Data Validation... Settings Allow Custom Formula
=A1=0
--
Gary''s Student - gsnu200741


"dalymjl" wrote:


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.




--
dalymjl

Enter only positive numbers
 

And another one
DataValidationSettings

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


HTH
Martin


"dalymjl" wrote in message
...

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.




--
dalymjl

Enter only positive numbers
 

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

=abs(a1)

God Bless

Frank Pytel

"dalymjl" wrote:


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.




--
dalymjl