View Full Version : how to validate cell input for 10 digits only?
asylum
10-15-2008, 08:08 PM
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
10-16-2008, 12:56 AM
Use Data>Validation with a type of Custom, and a formula of
=AND(ISNUMBER(E1),LEN(E1)=10)
Bob Phillips
10-16-2008, 01:03 AM
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
10-19-2008, 08:04 PM
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.
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.