Can you do a similar trick to F5-Special- etc to select all 0 values in a
range and then delete them, like you can with #n/a and errors

See if this helps:

I'm not sure which versin of Excel first featured this....

EditFind
Find what: 0 <-zero
Click the [Find All] button
(That will select the first zero, but all other "hits" will be listed in the
lower section of the Find window)

NEXT...while still in the window...
Press [Ctrl]+A (to select all items)
(All cells with zero should now be selected)

Click the [Close] button to close the window.

Press the [Delete] key to clear the contents of the seleted cells


Does that help?

***********
Regards,
Ron


"Lee Harris" wrote:

Can you do a similar trick to F5-Special- etc to select all 0 values in a
range and then delete them, like you can with #n/a and errors

"Ron Coderre" wrote in message
...
See if this helps:

I'm not sure which versin of Excel first featured this....

EditFind
Find what: 0 <-zero
Click the [Find All] button
(That will select the first zero, but all other "hits" will be listed in
the
lower section of the Find window)

NEXT...while still in the window...
Press [Ctrl]+A (to select all items)
(All cells with zero should now be selected)

Click the [Close] button to close the window.

Press the [Delete] key to clear the contents of the seleted cells


Does that help?

***********
Regards,
Ron


magic - that works just fine, many thanks Ron

Another option would be to edit|replace 0 with #n/a

Then you could use the F5 stuff to clear the errors.

Lee Harris wrote:

Can you do a similar trick to F5-Special- etc to select all 0 values in a
range and then delete them, like you can with #n/a and errors

--

Dave Peterson