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

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

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

Try the following custom format:

1. Select Format | Cells |Custom
2. Enter
--
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

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

How about the simple expediant of going to Tools/Option/View and deselecting
"Zero values".

Roger

"LPS" wrote:

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

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

The drawback with that is that it affects the whole sheet as opposed to
custom formatting

--

Regards,

Peo Sjoblom

"RogerN" wrote in message
...
How about the simple expediant of going to Tools/Option/View and
deselecting
"Zero values".

Roger

"LPS" wrote:

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