F5 function for zeroes?
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
|