Dropdown list

[Tonso]

Using XL 2003, i have a workbook that has hundreds of cells to enter
data in. i want the user to be able to select from a dropdown list.
The data that would be in the list would look something like this..
1 15 minutes
2 23 minutes
3 33 minutes
4 44 minutes
etc, etc.

What i would like to do is to have the dropdown list available so the
user could see where the minute value they have falls, then select the
value, and then only the number to the left (1,2,3,4, etc etc) would
be displayed in the cell. Also, the column widths are narrow (3.33, or
37 pixels), so I have to overcome this limitation in order for the
entire list width to be visible.

Thanks,

Tonso

 

[Pete_UK]

You can use Data | Validation to set up the available values for the
cell(s) (select them all first if more than one). Choose List from the
Allow drop-down on the dialogue box, and in the Source box list the
values like 15,23,33,44 and so on.

Then you can apply a Custom Format to those cells:

0" minutes"

However, you will need a wider column width to display the full
format.

Hope this helps.

Pete

 

[Tonso]

You can use Data | Validation to set up the available values for the
cell(s) (select them all first if more than one). Choose List from the
Allow drop-down on the dialogue box, and in the Source box list the
values like 15,23,33,44 and so on.

Then you can apply a Custom Format to those cells:

0" minutes"

However, you will need a wider column width to display the full
format.

Hope this helps.

Pete




- Show quoted text -

Thanks so much Pete! This sounds like an excellent solution, and i
start work along those lines immediately!
Thanks again...
Tonso

 

[Pete_UK]

You're welcome, Tonso - thanks for feeding back.

Pete