Data Validation

[wild turkey no9]

Guys

Using version 2003. I'm enterng a comma separated text list in the data
validation source dialog box. Is there a way to make the first list entry
blank?

Thanks in anticipation

Kevin

 

[wild turkey no9]

Worked like a charm. Many thanks, Micky

Assuming you want to have the letters a --> e.
As the Source type: X,a,b,c,d,e - where instead of the X you will press the
key combination: ALT+0160
[use the small numeric pad to for the digits].
Micky

Guys

Using version 2003. I'm enterng a comma separated text list in the data
validation source dialog box. Is there a way to make the first list entry
blank?

Thanks in anticipation

Kevin