ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/261325-data-validation.html)

wild turkey no9

Data Validation
 
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

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



All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com