Are the values actually zero, or are they maybe just smaller than .05 and
round to 0.0? You could check by formatting cells as general or to many
decimal places. If they're small but not zero, you can use the round
function to actualy reduce them to zero.

"Kendall" wrote:

I've had this a few times before. I have a number format specifying to show
zeroes as a dash ("-" in number format). Some of the cells show the dash,
but others show 0.0.

I've tried changing the "zero values" checkbox in Options just in case that
created problem. I've tried copying/pasting custom formula in the incorrect
cells. I've tried manually adding a new custom format the same as the
correct cells. I don't know what else to try.

I'm in an acctng firm, so VERY important for official financial statements
to have the same formats in all the cells.

Please help.