Results 1 to 2 of 2

Thread: Pivot Table Date Format

  1. #1
    Seeker xcel's Avatar
    Join Date
    May 2018
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Pivot Table Date Format



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am working with a simple pivot table. When i drag and drop my date to rows of pivot table it shows up in "1-Jan" format but i want it to show up as "01/01/17" format. I tried to convert date in field settings of pivot table but did not work. I also tried to change number formatting but no luck. Any idea why its behaving like that.

    Thanks

  2. #2
    Neophyte AceOne's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    Office 365

    pivot table & date format

    Quote Originally Posted by xcel View Post
    Hi,
    When i drag and drop my date to rows of pivot table it shows up in "1-Jan" format but i want it to show up as "01/01/17" format. I tried to convert date in field settings of pivot table but did not work.
    Thanks
    Hi pivot table query person
    when I make a pivot table - at the stage of dragging to date to rows, I clicked the down arrow on the date label in the "rows" portion down the bottom of the Pivot Table Fields window. On the down arrow click, I selected "Field Settings", and followed my nose.
    When I tried it with date like dd/mm/yyyy, it came out that way.

    Hang in there and give it another try.

    base data
    date
    div fc
    24-Apr-18 $ 482.12 206.62
    23-Oct-17 $ 452.14 193.77
    $ 934.26 $ 400.39
    Row Labels Sum of div Sum of fc
    apr 2018
    oct 2017
    24/04/2018 482.12 206.62
    23/10/2017 452.14 193.77
    Grand Total 934.26 400.39

Posting Permissions

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