Well, this should be number 11 as the fiscal year starts from November.

"T. Valko" wrote:

If you select October from the drop down list what value should that equate
to?

--
Biff
Microsoft Excel MVP


"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?