HELP! cell validate

[Guest]

i want to validate two cells

first one: only alphabet a-z A-Z

second one: it should be a number but it can have a
decimal place 0-9 & .

i want a MsgBox "error" to appear if the user enters in
something not valid.

how do i validate these? pleaaaase help!

 

[Tom Ogilvy]

Use data validation.

Jake Marx just posted this formula in response to a similar posting:

=25*LEN(A1)=SUM(LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW($A$65:$A$90)),"")))
(this is an array formula, but used in validation, it should require any
special attention (untested). )

for the second, use the build in choice of decimal and specify your bounds.
Your statement of the restriction sounds like it can be a decimal number.
If it is more restrictive than that, then you have not stated that clearly.

 

[Guest]

hello,

i don't understand what this formula does?? can someone
please explain!