Here is the formatting I'm currently using:

_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

This allows me to display all zero amount cells as "-" instead of 0's.

The problem I have is for cells that contains small negative balances under
..50 - those cells do not format to "-" but to (0). So the report looks
silly, with -'s on all zero+'s and (0) on all zero-'s.

Is there a cure for this grand malaise? TIA.