A
Arun
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?
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?