Substitute "$ 0.00" for "$ - " in Excel 2013 Accounting number format

[metsmaniac]

How do I substitute "$ 0.00" for "$ ​- " in Excel 2013 Accounting number format?

 

[NeonRedSharpie]

_($* #,##0.00_);_($* (#,##0.00);_($* "0.00"??_);_(@_)

 

[adam087]

I got it using this number format (entered in the 'Custom' group).
_-[$$-409]* #,##0.00_ ;_-[$$-409]* -#,##0.00 ;_-[$$-409]* "-"??_ ;_-@_
Hope that helps
/AJ

 

[metsmaniac]

Thanks. That worked. I had to modify that a little because the "0.00" wasn't lining up with the other numbers. It was centered even though I didn't have format set for centering.

So it looks like this:
_($* #,##0.00_);_($* (#,##0.00);_($* "0.00"_);_(@_)

Thanks again.

 

[adam087]

NP. Thanks for the feedback

/AJ