Pivot Table field gets NA or Div/0 show 0.00, but not formatting nicely

[rcdavis28]

Hello All,

I have a field in a pivot table that is troubling me. I went to pivot table options and have it set to show 0.00 if there is an error. It is doing this fine, but it places it in the cell generically left-aligned and does not match the accounting format that the rest of the values in the field have. It just looks bad. Is there a way to fix this or maybe some code to fix this?

Thanks,

Ryan

 

[RoryA]

You could type in the exact formatted string you want and right align the column.