Override IFERROR's "0" with formatting "-" ????

[Silverjman]

I need my IFERROR "0" to be replaced with my formatting which represents all zeros with a dash. However a dash "-" in an IFERROR seemingly doesn't equal a zero in that my formulas that depend on that cell will #VALUE out....THANKS!!!!!!!

 

[Oeldere]

Reading your question correctly.

0 is not equal to - (dash)

That is correct, so i expect a #value as result.

So what is your problem?

 

[VorLag]

Here's a guide that shows you how: Replacing Zeros with Dashes in Number Formatting | Excel Format

 

[Silverjman]

I want the value in my IFERROR cell to equal 0 but appear as a dash.

 

[RoryA]

Change the number format of the cell rather than changing the formula. Unless your formula really is IFERROR(...,"0") in which case you want IFERROR(...,0)

 

[Silverjman]

I was dense

 

[Silverjman]

THANKS RORY that did it, and all, you guys are great (sent this first but guess it didn't go through) I was way too in love with my "", bit embarrassing but thanks so much for the education!!!!