Excel Pivot Table Help!

Options
mrsdangermouse
mrsdangermouse Registered Posts: 5 New contributor 🐸
in General discussion
Hi,

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:

Comments

  • pablod
    pablod Registered Posts: 9 New contributor 🐸
    Options
    Hi,

    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!

    paul
  • mrsdangermouse
    mrsdangermouse Registered Posts: 5 New contributor 🐸
    Options
    Thanks :thumbup1:

Categories

Privacy Policy