Number Formatting

  • Thread starter Thread starter Nan
  • Start date Start date
N

Nan

I want all the cells in my worksheet to have the accounting format wit
any $0 dollar entries to appear as a "-". Some of the cells have a "0
or "(0)" instead. I have copied the proper formats to all cells bu
can't seem to get them all to look the same. I'm not sure why this i
happening. Any ideas?
 
The value is probably not zero but it is less than your display is showing.
If you use the accounting format with no decimal places and the value in the
cell is less than 0.5 it will display "0". If you enter a 0 in the cell it
will display "-".

Carlos
 
Back
Top