How do I make the 0 hidden with erasing the formula in a block?
 

Try the following custom format:

1. Go to Format | Cells | Number | Custom
2. In the "Type" field, enter: $#,##0.00;-0;;@

You can also omit the dollar sign at the start if you want.

Hope this helps
--
LPS


"floydgrading" wrote:

Please help asap. I have a project due and I dont want all those zeros on
the page but I dont want to erase all my formulas. I need them there for
when I plug in my numbers.
--
tm