Re: WEEKDAY()

In A2 enter:
=A1
*Then* format A2 to mmmm!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MartinW" <mtmw@xxxxxxxxxxxxxxx> wrote in message
news:uQJWow60GHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Bob, of course it is I should have seen that...duh!
So to get a return of September I can see a way of doing it by
hiding the month cell and a Vlookup table somewhere out of the
way and using a Vlookup in A2. Is there a simpler method?

Thanks again
Martin



.

Relevant Pages

  • Re: VLOOKUP PROBLEM
    ... Please keep all correspondence within the NewsGroup, ... "Gilbert" wrote in message ... >>> The format on both columns are the same. ...
    (microsoft.public.excel.misc)
  • Re: How do I continue this pattern in excel?
    ... Please keep all correspondence within the NewsGroup, ... >> To change the format of the range to General, ... >>> Is the cell it's entered in formatted as General, ...
    (microsoft.public.excel.misc)
  • Re: Formatting SS#s without hyphens
    ... "RagDyer" wrote: ... Please keep all correspondence within the NewsGroup, ... like to format the entire column before importing to the spreadsheet. ...
    (microsoft.public.excel.misc)
  • Re: Leader Dots Between Cells
    ... I still can see a "seam" between the columns in some of the rows. ... Please keep all correspondence within the NewsGroup, ... Format your dots *only* in the right column. ...
    (microsoft.public.excel.newusers)
  • Re: VLOOKUP AND #N/A
    ... Please keep all correspondence within the NewsGroup, ... I tried 3 other answers given in the archives first but still haven't been ... I'm looking for for an exact match to A6 in column H of my VLOOKUP table ...
    (microsoft.public.excel.worksheet.functions)
Loading