How To Return a $0.00 in accounting format when ther is error or Div/0 in pivot table

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

Create an IF formula OR hard code the zeros. =if(iserror (A1/A2),0, +A1/A2). it would be easier if i saw your issue. Good luck