Display 0's in Accounting format
 

I use the Accounting format to align numbers and dollar signs. How can I make
zero display as the number rather than a dash?
--
- markvi

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


--

Regards,

Peo Sjoblom


"markvi" wrote in message
...
I use the Accounting format to align numbers and dollar signs. How can I
make
zero display as the number rather than a dash?
--
- markvi

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

"markvi" wrote:

I use the Accounting format to align numbers and dollar signs. How can I make
zero display as the number rather than a dash?
--
- markvi

Thanks to you both!

"tjtjjtjt" wrote:

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

"markvi" wrote:

I use the Accounting format to align numbers and dollar signs. How can I make
zero display as the number rather than a dash?
--
- markvi