Limit value entered into cell

[Shaun]

Hi All


I am trying to limit the value entered into a cell by a user to between 0% and 100%. I am not sure of how to do this. Could anyone help?


Cheers


Shaun

 

[Hui]

Shaun


You can use Data Validation for this

Select the range of cells you wish this to apply to

Assuming A2:A10


Goto Data, Data Validation

Allow: Decimal

Data: Between

Minimum: 0

Maximum: 1

Apply


or


Goto Data, Data Validation

Allow: Custom

Formula: =AND(A2>0,A2<1)

Apply


assumes the top left cell of the range is A2

 

[Shaun]

Thank you Hui, it works perfectly.


Cheers


Shaun