Formatting zeros as dashes
 

I have a worksheet with the data formatted as currency with no decimal
places. I would like all my zeros to show up as dashes. For example, no $
0 or $ (0). I understand that if the number is not exactly zero, it won't
use the dash, ie. a .25 will show up as a 0... but this is what I would like
to override. I also don't want to actually change the value in the cell
using the rounding functions.

Simply put, how do I get it to choose the format based upon the display
accuracy of the value versus the true value?

Formatting zeros as dashes
 

Ann:
If you think about it there is no way for Excel to do this. How close to
zero must the value be to be shown as a dash? Excel cannot make that guess.

You could use a helper column with ROUND and hide the original column
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Arun" wrote in message
...
I have a worksheet with the data formatted as currency with no decimal
places. I would like all my zeros to show up as dashes. For example, no
$
0 or $ (0). I understand that if the number is not exactly zero, it won't
use the dash, ie. a .25 will show up as a 0... but this is what I would
like
to override. I also don't want to actually change the value in the cell
using the rounding functions.

Simply put, how do I get it to choose the format based upon the display
accuracy of the value versus the true value?