Home For AAT student members General AAT student discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Excel Pivot Table Help!


I'm trying to format a column in a pivot table so that it shows the date as Feb-08 instead of 01/02/08. I would normally click on the field settings and then click number and change it there but I can't seem to get the number option to even appear. I can get it to appear on a different column and when I checked the original data it was formatted exactly the same.

Please help it's driving me crazy! :confused1:


  • pablodpablod New Member Registered Posts: 9

    Select your cells by dragging the mouse over the dates that you need changed and press ctrl+1 and it should go to the format cells window.

    in this go the bottom heading named custom, and from there you should see the option to use month-year, with no day.

    I hope this helps!

  • mrsdangermousemrsdangermouse New Member Registered Posts: 5
    Thanks :thumbup1:
Sign In or Register to comment.