Pivot Table Formatting

[Phoenix5794]

I have a few formatting issues with a Pivot Table here: PivotTableFormatting.JPG.

Given that I'm unable to change the width of my columns, I right align my cells within my pivot table and then allow them to overlap the cell to the left to accommodate for this.

The problem comes in with the header first: it gets cut off whereas the rows below it don't get cut off. (The cell to the left is empty just as the cells below it are).
If you notice, the SHS-050-300-A-6 item is overlapping as I'd like, but the headers do not.

Second, the pivot table on the right is filled with ####. The cells to the left are blank as they should and the only difference is that I have a custom format applied to them as such: [$HA Manifold Zone ]#.

Is there any way around this?

Thanks!

[Phoenix5794]

Are pivot tables simply this awkward to work with? I've plenty of difficulty getting them to conform to the formatting I want, but this seems to be a situation where it works sometimes, but not others (and that makes it difficult to pinpoint).