how to validate cell input for 10 digits only?

[asylum]

Help, anyone....

how to make the cell that only can be entered with 10 digits only,
let say if i want to input 9 digits only, it can't.

sorry, one more thing, how to apply the same condition with date only?

thanks.

[Bob Phillips]

Use Data>Validation with a type of Custom, and a formula of

=AND(ISNUMBER(E1),LEN(E1)=10)

[Bob Phillips]

Missed the second part.

Again Data Validation, again a type of Custom, with a formula of

=AND(ISNUMBER(E1),E1<TODAY()+182500)

this will allow any date up to 500 years forward.

[asylum]

Hi XLD, thanks alot for your reply...
sorry....i've tried what you've mention, but i couldn't...
i did exactly what you've typed above...but it kept say "error".

thanks.

[GTO]

Hi asylum,

Just checking, you are putting this into cell 'E1' right? Or adjust the formula as necessary.. I just tried and it works fine

Mark