the user that fills out the form needs to see 123 Apples, the end user
doesn't need to see it.
What is an event change macro?
"Biff" wrote in message
...
Hi!

If you have in your list:

123 apples
123 oranges

How will you know what 123 refers to?

This can probably be done with an event change macro.

Biff

-----Original Message-----
hi all,
I'm using excel 2000.
Is there a way to have a drop down list that displays the
full text, but
upon selection only returns the first 3 characters? for
example,
in the list I have : 123 apples, 345 Oranges.
I want the Users to see "123 apples", but when they
choose it, only "123" is
placed in the cell.

TIA

James


.