Display 0's in Accounting format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the Accounting format to align numbers and dollar signs. How can I make
zero display as the number rather than a dash?
 
Use this Custom Number Format:
_($* #,##0.00_);_($* (#,##0.00);_($* 0??_);_(@_)

This is the code for Excel's built-in Accounting Style with the dash
replaced with a zero. Look after the second semicolon to see the change
(demonstrated below).
This: _($* "-"??_)
has been changed to: _($* 0??_)

tj
 
Thanks to you both!

tjtjjtjt said:
Use this Custom Number Format:
_($* #,##0.00_);_($* (#,##0.00);_($* 0??_);_(@_)

This is the code for Excel's built-in Accounting Style with the dash
replaced with a zero. Look after the second semicolon to see the change
(demonstrated below).
This: _($* "-"??_)
has been changed to: _($* 0??_)

tj
Click to expand...
 
Back
Top