+ Reply to Thread
Results 1 to 6 of 6

Covert Date DD/MM/YYYY in to month, with the month as text

  1. 11-23-2012, 06:24 AM #1
    david1987
    david1987 is offline
    Registered User
    Join Date
    08-20-2012
    Location
    Glasgow
    MS-Off Ver
    Excel 2007
    Posts
    77

    Covert Date DD/MM/YYYY in to month, with the month as text

    Hi,

    I have a list of dates in the following format, e.g. 01/10/12, I want to pull the text 'October' from this.

    I have achieved this by changing the formatting, but I want it to be the text and not still the date behind the information.

    Thanks

    David
    Reply With QuoteRegister To Reply
  2. 11-23-2012, 06:32 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,155

    Re: Covert Date DD/MM/YYYY in to month, with the month as text

    =TEXT(A2, "mmm") ... for example

    If you then want it "fixed", Copy the formulae and then Paste Special | Values


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 11-23-2012, 10:40 AM #3
    sonic-boom
    sonic-boom is offline
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Covert Date DD/MM/YYYY in to month, with the month as text

    If you want the name of the month in complete,
    =TEXT(A2,"mmmm")
    Reply With QuoteRegister To Reply
  4. 11-23-2012, 10:54 AM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,155

    Re: Covert Date DD/MM/YYYY in to month, with the month as text

    @sonic-boom: good spot, I missed an "m"
    Reply With QuoteRegister To Reply
  5. 11-23-2012, 10:59 AM #5
    sonic-boom
    sonic-boom is offline
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Covert Date DD/MM/YYYY in to month, with the month as text

    My pleasure
    Reply With QuoteRegister To Reply
  6. 11-23-2012, 11:03 AM #6
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Covert Date DD/MM/YYYY in to month, with the month as text

    ..........
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1