I want the GL definitions to be seen in the drop down menu when it is opened,
but not displayed in the cell itself once the appropriate GL number is
selected. In other words, the user needs to see the GL definition and may,
but does not have to, see the GL number itself. However, once clicking on the
correct GL definition/number, only the number (not the definition) should
display in the cell.

Is this more clear?

"David Cox" wrote:

and where and when do you want the GL definitions to be able to be seen?


"Orion96" wrote in message
...
I can set up a drop down menu using validation just fine, but would like to
be able to show more information in the menu than is actually inserted
into
the cell. Is there a way to make this happen?

Ex:

The information is a list of GL codes and what expenses they represent.
While I want the user to be able to see the GL code definition, I only
want
the GL code number itself to display.

I threw this out to the best Excel developer I know and he is stumped. It
seems like this is not that unusual a need and should have a way to make
it
happen. Any advice?