Control On Cell Input

L

Laura11

Hi, how do I put a control on a cell so that only a "-" i.e. -8 can be
entered or conversely a control so that only a positive number can be entered.

Thanks so much.
 
P

p45cal

Hi, how do I put a control on a cell so that only a "-" i.e. -8 can be
entered or conversely a control so that only a positive number can b entered.

Thanks so much.
Click to expand...


Data|Validation...
Allow:Decimal (or WholeNumber)
Data:'less than or equal to'
Maximum:0
OK.

for positive numbers, it should be obvious now.
 
Top