Display 0's in Accounting format

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?
 
G

Guest

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting number 7
Dollar sign alignment - Accounting vs Currency style 3
Forumla rows and columns 3
zeros show as dashes in spreadsheet, want to show 0. 2
custom number format 1
Why are there inconsistencies in the display of zeroes in account. 5
Formatting 0 values to show blank cells 4
Number format 1

Top