| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
drop down menu length
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add option to drop down menu | Excel Discussion (Misc queries) | |||
| How to add a drop down menu to a cell | Excel Discussion (Misc queries) | |||
| drop down menu containing worksheet names | Excel Worksheet Functions | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
Threaded Mode
