+ Reply to Thread
Results 1 to 6 of 6

Convert Number into Month and Year

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    584

    Smile Convert Number into Month and Year

    Dear Friends,

    I have a column in which the numbers are entered like:

    1112
    1112
    1212
    1212
    1212
    0113
    0113
    0113

    I want to convert the above data as (MMM-YYYY format):

    1112 - as Nov-2012
    1212 - as Dec-2012
    0113 - as Jan-2013

    Is it possible? Kindly help me.
    Good friends are hard to find, harder to leave, and impossible to forget.

    acsishere.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Convert Number into Month and Year

    Perhaps
    Please Login or Register  to view this content.
    and format as needed

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Convert Number into Month and Year

    If your numbers start in A1, try this in B1. Format the result as Custom: mmm-yyyy

    =DATE(RIGHT(A1,2)+100,LEFT(A1,2),1)

    - Moo

  4. #4
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    584

    Re: Convert Number into Month and Year

    Dear Friends,

    Excellent reply and thanks for your swift response.

    After applying the formula it works exactly. However, it considers the first day of the related month.
    But, how to get the last of that month? is there any solution?

  5. #5
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Convert Number into Month and Year

    maybe..

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  6. #6
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    584

    Thumbs up Re: Convert Number into Month and Year

    Thanks to all for immediate solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1