see my earlier post

"go to Data-Data validation..."


On 3 Cze, 13:16, Ridhi wrote:
but we cannot make user enter a value in a cell which already contains a
formula.



"Jarek Kujawa" wrote:
go to Data-Data validation, choose last posiotion on the list
(Userdefined or non-standard, am not sure)

in formula window put the following:

AND(A1=3,A1=<8)

for "alphabets" use:
=OR(AND(CODE(A1)=65,CODE(A1)=<90),AND(CODE(A1)=9 7,CODE(A1)=<122))

On 3 Cze, 12:40, Ridhi wrote:
Is there any way to display a mesage if *wrong value is entred in the cell.

Can we restrict a user to enter only a numeric value in a cell which is with
in a certain range like value between "3-8" or alphabets only.

Please help- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -