xriphenburg
New Member
- Joined
- Aug 22, 2017
- Messages
- 1
Right now I am working with a data table, to which I added a 'Month' column, as an integer (1 for January, 2 for February, etc.). While pulling this data into Pivot Tables using the Month column, I wanted to display the months as actual names Months - 'January, February', etc. When I edit the Number Format within the Pivot Table, Excel recognized my integers as days. So when I convert the Format into 'mmmm' everything is showing as 'January'.
So essentially, when I have Month 4 in my column, I want it to display as April in my Pivot Table. But Excel recognized this integer as d, so in d-mmm format it would show as 4-Jan. So all of my months are displaying as 'January' when I want them to show the full month name.
Not having fun. what do?
So essentially, when I have Month 4 in my column, I want it to display as April in my Pivot Table. But Excel recognized this integer as d, so in d-mmm format it would show as 4-Jan. So all of my months are displaying as 'January' when I want them to show the full month name.
Not having fun. what do?