+ Reply to Thread
Results 1 to 3 of 3

Convert date to month/year text

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Convert date to month/year text

    I have dates that are entered in the 12/1/2012 format. I converted them to show up as Dec-12. I then created a pivot table based on this data and they are being sorted based on individual dates, not months as I had intended. Whenever I click on a cell that says Dec-12, it shows the actual number in the cell as 12/1/2012. How do I fix this to sort by months? Or to have the text actually show up the cell so it will sort correctly?

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

    Re: Convert date to month/year text

    Right click your field with dates and click " Group" - Then select months - You can now sort / work with months - Grouping will not work if you have blank cells though

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Convert date to month/year text

    This then gets rid of the year, which I need as well.

+ 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