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
|