Re: Month text as a value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <DaveKid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F16EBA85-723F-4857-B6ED-3BFA75B29358@xxxxxxxxxxxxxxxx
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
.

Relevant Pages

  • Re: OT. Good programming techniques (or not)...
    ... > Should I worry about inefficiency if it works? ... Do real programmers spend much time "optimising" ... Reply to john at yclept dot freeserve dot co dot uk ...
    (uk.comp.sys.mac)
  • No thank you Re: Do you come up against the situation?
    ... you dot want to play yourself or you just dot have much time and so ... Don't worry, come here www.icoolgames.com,and you will get ...
    (alt.games.warcraft)
  • Re: Worst DOT States
    ... If you have your "shit" together you shouldn't have to worry about ... Make sure your logs are legal and up to date. ... Do all this and you'll be able to pass any DOT ... I generally dont worry about dot except in states I dont go to ...
    (misc.transport.trucking)
  • Re: Java
    ... wn DoT com DoT au"> says... ... > have to worry about garbage collection. ... but not a complete degree program without low-level programming. ...
    (comp.programming)
  • Re: Do you come up against the situation?Come up to this powerleveling!
    ... you dot want to play by yourself or you just dot have much time and ... Don't worry, come here www.icoolgames.com,and you will get ... First time I've seen a bridge pro advertise on rgb!!! ...
    (rec.games.bridge)