The dot didn't work for me (my USA settings???).

But this did:
=MONTH(A1&" 1, 2008")

As did this:
=MONTH("1"&A1&"2008")
and
=MONTH(1&A1&2008)
(and I didn't have to worry about the separator)

Harald Staff wrote:

Another:
=MONTH(A1&" 1. 2008")

Best wishes Harald

"DaveKid" wrote in message
...
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?

--

Dave Peterson