Prev: How to use the Stop If True Condition for highlight cells
Next: Why does it display #### in my cell?
From: Laura11 on 13 Mar 2010 22:18
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.
From: p45cal on 14 Mar 2010 04:41

Laura11;670644 Wrote:
>
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.


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

for positive numbers, it should be obvious now.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=187338

http://www.thecodecage.com/forumz/chat.php

 | 
Pages: 1
Prev: How to use the Stop If True Condition for highlight cells
Next: Why does it display #### in my cell?