How do I show zero in Accounting format ?

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

Guest

I want to show the zero in my spread sheet not the dash but want to also show
the $ sign. Any ideas....
 
Not sure really what you what but this might work

=IF(A1="","$0.00",A1)
 
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.
 
You must log in or register to reply here.

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

Displaying zeros in cells 2
How do I insert hyperlinks in blank cells 6
Adding recognised Zeros 5
Calculation / Format Error 1
Remove Dashes from Social Security Numbers 8
Show zero values in specific area 4
NumberFormat for small non-zero numbers? 2
zeros show as dashes in spreadsheet, want to show 0. 2

Back
Top