Hi
one way:
See:
http://www.contextures.com/excelfiles.html
and search for
Data Validation "Columns"


--
Regards
Frank Kabel
Frankfurt, Germany
"Markitos" schrieb im Newsbeitrag
...
Hello

I was wondering if their is any way to have a drop down box that will hold
both an account number and account name but only input the account number
into the box. Or if their is another or better way to do this.

Thanks-Mark