Hi, Is there a way to restrict user to enter negative values into a cell? TIA eric :(
E ericlye Aug 27, 2003 #1 Hi, Is there a way to restrict user to enter negative values into a cell? TIA eric
L Leo Heuser Aug 27, 2003 #2 Hi Eric One way: Select the range (e.g E34:E56) Data > Datavalidation > Custom enter this formula =E34>0 -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please.
Hi Eric One way: Select the range (e.g E34:E56) Data > Datavalidation > Custom enter this formula =E34>0 -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please.
