+ Reply to Thread
Results 1 to 5 of 5

Date format in pivot table headers

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    58

    Date format in pivot table headers

    Each time I make a pivot table with dates (month and year) in Columns, there is a always the 1st day of each month in the header. How can I change it so that there is only a month and year, i.e. 06/2016 instead of 01/06/2016?
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Date format in pivot table headers

    1. Select all column labels
    2. right click and select 'field settings'
    3. go to 'Number format' option
    4. in opened 'Format cells' dialog box select 'Custom'
    5. In the 'Type:' field, enter 'mm/yyyy' and check it is showing the value under sample for example '10/2016'
    6. click Ok till all dialogue boxes closed
    Last edited by Sum; 10-10-2016 at 06:48 AM.

  3. #3
    Registered User
    Join Date
    12-31-2012
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    58

    Re: Date format in pivot table headers

    I only see options like this:
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Date format in pivot table headers

    Which version of office ?
    Last edited by Sum; 10-11-2016 at 11:42 PM.

  5. #5
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Date format in pivot table headers

    Try below:
    1. Select all column labels
    2. right click and select 'Format Cells'
    3. go to 'Number format' option
    4. in opened 'Format cells' dialog box select 'Custom'
    5. In the 'Type:' field, enter 'mm/yyyy' and check it is showing the value under sample for example '10/2016'
    6. click Ok till all dialogue boxes closed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date format in pivot table
    By Shadmani in forum Excel General
    Replies: 2
    Last Post: 07-26-2016, 10:29 AM
  2. Cant change date format in Pivot Table
    By Ricksterr94 in forum Excel General
    Replies: 0
    Last Post: 08-01-2014, 12:34 PM
  3. Date format in Pivot table.
    By srmani44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2012, 08:03 AM
  4. [SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:18 AM
  5. Pivot Table Date Format/Sort
    By devo in forum Excel General
    Replies: 4
    Last Post: 08-07-2012, 04:50 PM
  6. How to format date for pivot table graph
    By Onestopfanshop in forum Excel General
    Replies: 3
    Last Post: 09-11-2010, 06:43 AM
  7. Excel 2007 : Pivot Table Date Format
    By techiemom60 in forum Excel General
    Replies: 0
    Last Post: 02-16-2010, 04:29 PM

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