How do I format a cell in Excel to show a dash instead of 0.00?

R

Reb3boys

In Excel, I have two cells that are both formatted as accounting, decimal 2
and symbol none.
One cell returns a dash -, the other 0.00.
I want both cells to return a -.
I have tried to paint the formatting but it still doesn't work.
Thanks
 
N

Niek Otten

The 0.00 one is not exactly zero. Format temporarily as General and you'll
see there are some digits beyond the two decimals.
Use ROUND() to round to zero
 

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

Paste to excel from word - auto format problem 1
Word macro that can call cells out of Excel for a find and replace 0
In Excel, show 0.00 for "zero" entries, but "-" if no entries 1
accounting format for zero show 0.00 in one cell "-" in another 5
Accounting format returns a - for zero other cells show 0.0 Why? 5
zeros show as dashes in spreadsheet, want to show 0. 2
Formatting 0 values to show blank cells 4
Cell Shows 0.00 but still has a number 2

Top