Drop down menus

[Guest]

I learnt how to do drop down menus for cells, but I would like the drop down
menu to display one word but enter in a different character in the cell when
it is selected.

 

[Debra Dalgleish]

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You should be able to adapt this
to your workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under the data validation heading, find 'Data Validation "Columns"' and
download the file named DataValNameID.xls