Share via

Row format in pivot table

Anonymous
2018-10-01T14:21:24+00:00

How do I change the formatting of the row values in a pivot table? My row data is being displayed as a date but it should be a 6 digit integer number. I can change the formatting of the values fields, but not the row.  I have tried Field settings and Pivot Table Options > Layout & Format without success. I also checked the formatting in the table from where the data is obtained. And if I just change the cell formatting, the new formatting disappears next time I use the pivot table. Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-10-01T14:29:21+00:00

    You can try selecting the entire column and then format the column rather than driving it through pivot table. This is a pivot table limitation.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-10-01T14:54:43+00:00

    I tried that in the past, but when I change the formatting that way, it doesn't stay that way very long. I'm still trying to figure out what triggers the formatting to reverting back. Thank you for your response.

    Was this answer helpful?

    0 comments