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" <markvi@discussions.microsoft.com> wrote in message
news:3B30CFB4-7CAE-419B-88F2-73A80DB42C6B@microsoft.com...
> 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