No this doesnt wortk either.

"Ron Rosenfeld" wrote:

On Mon, 27 Oct 2008 09:24:05 -0700, DaveKid
wrote:

Hi, I am wokring on a spreadsheet which gives the month name in a drop down
list to select. This drop down box is then linked to another cell which reads
is contents to give the value dependent on which month is chosen, however, I
have a problem in that excel cannot read the month as a value. How do I
overcome this?


I assume your month names are in a list someplace, in order, so:

=MATCH(A1,List_of_Months,0)

will return the number of the month.
--ron