Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
wild turkey no9 wild turkey no9 is offline
external usenet poster
 
Posts: 20
Default Data Validation


Worked like a charm. Many thanks, Micky

"מיכאל (מיקי) אבידן" wrote:

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


"wild turkey no9" wrote:

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