Control On Cell Input

[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.

 

[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.

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

for positive numbers, it should be obvious now.