RE: Number format exactly the same, displays differently in some cells

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.

Thank you--that's a good thought; however, they're actually zeroes, not
formulas at all.