Results 1 to 6 of 6

Thread: Date format in Pivot table not changing

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    33
    Articles
    0
    Excel Version
    365

    Date format in Pivot table not changing

    I've created an example Pivot table that has a few categories in a table that feeds into a Pivot Table.

    The date formatting in the Table is set to mmm d, yyyy and in fact appears that way.

    The pivot table shows the formatting as mmm d, yyyy but instead appears as d-mmm.

    I've tried playing around to change it but nothing seems to change the formatting.

    Is it possible to change the formatting or am I stuck?

    If so, what are the steps?

    Thanks.
    Attached Files Attached Files

Posting Permissions

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