Coding drop down list results as numbers

[chan_siu_man]

I was wondering if there is a way to have excel code results from a drop down list numerically?

ie, let's say we do Days of the week. Ideally, I'd like to create a spreadsheet such that the drop down menu lists the days of the week Mon-Fri, but after I've clicked on the day I want, it enters a number into the excel cell (Mon-1, tues-2, wed-3 etc..)

Is there a way to do this?

Thanks,
Simon

[Biff]

Hi!

You can use a combo box from the forms toolbar and link the cell where you
want the number to appear. The linked cell will return the number of the
item selected that is relative to the list:

Monday
Tuesday
Wednesday

If you select Tuesday the linked cell will return 2 because Tuesday is the
second item in the list.

Or, use this formula:

Assume the drop down is in cell A1.

Enter this formula in cell B1:

=IF(A1="","",MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday"},0))

Biff

"chan_siu_man" <chan_siu_man.24qmym_1142471400.982@excelforum-nospam.com>
wrote in message
news:chan_siu_man.24qmym_1142471400.982@excelforum-nospam.com...
>
> I was wondering if there is a way to have excel code results from a drop
> down list numerically?
>
> ie, let's say we do Days of the week. Ideally, I'd like to create a
> spreadsheet such that the drop down menu lists the days of the week
> Mon-Fri, but after I've clicked on the day I want, it enters a number
> into the excel cell (Mon-1, tues-2, wed-3 etc..)
>
> Is there a way to do this?
>
> Thanks,
> Simon
>
>
> --
> chan_siu_man
> ------------------------------------------------------------------------
> chan_siu_man's Profile:
> http://www.excelforum.com/member.php...o&userid=32503
> View this thread: http://www.excelforum.com/showthread...hreadid=522920
>