Pivot Table Cell Formatting

[Guest]

What's the trick to getting Row fields to get consistent and repeatable
alignment formatting? I have a Row field that is a number, and I'm trying to
get it to be Centered. It seems that some entries stay centered, but some
don't. I format the cell for center alignment, and all of the entries are
centered, but as soon as I refresh the table, a few of them revert to right
justified.

Any tips?

Todd

 

[Roger Govier]

Hi

Hover over the row Field name, until you see a black downward point arrow.
Click and all of the data for that field should be highlighted>click the
Center icon on the toolbar.