+ Reply to Thread
Results 1 to 3 of 3

How to change a format of date field in the pivot table?

  1. 01-25-2015, 07:34 PM #1
    geetu
    geetu is offline
    Registered User
    Join Date
    06-19-2013
    Location
    delhi
    MS-Off Ver
    2007
    Posts
    2

    How to change a format of date field in the pivot table?

    How to change a format of date field in the pivot table?
    Reply With QuoteRegister To Reply
  2. 01-25-2015, 08:14 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to change a format of date field in the pivot table?

    Have you tried formatting as you would for any other cell?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 01-26-2015, 04:58 AM #3
    geetu
    geetu is offline
    Registered User
    Join Date
    06-19-2013
    Location
    delhi
    MS-Off Ver
    2007
    Posts
    2

    Re: How to change a format of date field in the pivot table?

    i want to through vba code?
    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)

Similar Threads

  1. Cant change date format in Pivot Table
    By Ricksterr94 in forum Excel General
    Replies: 0
    Last Post: 08-01-2014, 12:34 PM
  2. [SOLVED] change 'count of' to 'sum of' in pivot table field
    By Rob B in forum Excel General
    Replies: 3
    Last Post: 09-13-2012, 03:07 AM
  3. Date Format in Pivot table Row field (Excel 2003)
    By DavidBW in forum Excel General
    Replies: 4
    Last Post: 01-30-2012, 05:46 AM
  4. change the value of active field in pivot table
    By phoeberunner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2011, 08:10 AM
  5. Format a subtotal field in a Pivot Table?
    By dns22 in forum Excel General
    Replies: 0
    Last Post: 03-11-2005, 12:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1