Thread
:
Preventing Invalid Characters using data Validation
View Single Post
#
2
Posted to microsoft.public.excel.programming
NLiles
external usenet poster
Posts: 4
Preventing Invalid Characters using data Validation
Is this something that cannot be done?.. I see lots of peoples questions
being answered but not mine :)..
Thanks
"NLiles" wrote:
I'm trying to create a template for users to enter data and have it input
onto a spreadsheet, there are some conditions i need to set using data
validation and im not sure how to do it.. There cannot be any
spaces,-,&,%,#... etc.. in the fields, but Numeric and Alpha are ok. There
also can only be 10 characters in the field which is easy to define. I tried
using the custom validation but Im not familiar with how to create a formula
to achieve this goal.
Reply With Quote
NLiles
View Public Profile
Find all posts by NLiles