How to format numeric months to text months in a pivot table?

BittenApple · Post by **BittenApple** » 19 Sep 2021, 21:47

Hello team,

How to format numeric months to text months in a pivot table without changing the source data for the pivot table?

Regards,

Bitten

Post by **HansV** » 19 Sep 2021, 22:54

I don't think that's possible

BittenApple · Post by **BittenApple** » 19 Sep 2021, 23:37

Ok thanks

jstevens · Post by **jstevens** » 20 Sep 2021, 00:08

Bitten,

One possibility is to use Excel's Power Query to transform data and from that transformed data create the pivot table.

Here is an example of date formatting in Power Query.

BittenApple · Post by **BittenApple** » 20 Sep 2021, 02:30

John,
Thanks for it.
Bittenapple

Eileen's Lounge

How to format numeric months to text months in a pivot table?

How to format numeric months to text months in a pivot table?

Re: How to format numeric months to text months in a pivot table?

Re: How to format numeric months to text months in a pivot table?

Re: How to format numeric months to text months in a pivot table?

Re: How to format numeric months to text months in a pivot table?