Hello all,

Thank you for your time and attention to my post. I went to pivot table options and changed for it to show 0.00 if there is an error or div by 0. Now though, it is doing that, but it is left aligned and does not have $. This looks like an eye sore as someone would scroll down the field and see all the other data points formatted properly. Is there a fix for this?

Thanks