How do I show zero in Accounting format ?
 

I want to show the zero in my spread sheet not the dash but want to also show
the $ sign. Any ideas....

How do I show zero in Accounting format ?
 

Not sure really what you what but this might work

=IF(A1="","$0.00",A1)

"Jakesmom" wrote:

I want to show the zero in my spread sheet not the dash but want to also show
the $ sign. Any ideas....

How do I show zero in Accounting format ?
 

If you format the cell (showing the hyphen), then use:
Format|Cells|number tab
you'll see that the custom format is:
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
You could change it to:
_($* #,##0.00_);_($* (#,##0.00);_($* 0.00_);_(@_)

If you want to fix all the cells formatted with the Currency style, you could
use:

Format|Style|Select Currency
Click Modify and change the numberformat to what you like.

Be aware that styles live in workbooks. You'll have to do the same thing for
each workbook that needs it.


Jakesmom wrote:

I want to show the zero in my spread sheet not the dash but want to also show
the $ sign. Any ideas....

--

Dave Peterson