View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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