I am using Excel 2003 and am trying to set up a drop down box so that my
staff can use a pre-defined list of codes to populate a field in the
spreadsheet. So that the field width can stay managable each code will
consist of 2 or 3 characters (just like state abbreviations). To avoid
confusion and help staff remember what each code means, I would like the
explanation of each code to also appear in the drop down box or at least have
the explanation appear in the drop down box but have only the code appear in
the spreadsheet. For the life of me I just can't figure out how to do this.
Anyone have any suggestions.

agilek9