I have a date column that I'm pivoting so that the column header is the date, I've kept it as a date so that it's sorted properly. When I pivot it just shows the column as the number, how do I get it to keep the date format?
I have a date column that I'm pivoting so that the column header is the date, I've kept it as a date so that it's sorted properly. When I pivot it just shows the column as the number, how do I get it to keep the date format?
Did you leave the checkbox for Preserve formatting checked? Maybe this will help you.
As far as I know, column names can only be strings and not numeric values.
Haha - no.... Thanks for pointing that out!