How do I replace numbers in a value NOT a formula?
Thank you for the suggestion--it opened my eyes to a view option I wasn't
previously aware of--but I'll be taking averages of some of these rows
containing zeros. If the zeros are present but I'm not aware of them because
I turned them off, my averages will be skewed low.
"bpeltzer" wrote:
If you simply don't want to see anything where the cell value is zero, you
could use Tools / Options, select the View tab and clear the 'zero values'
checkbox.
"Riverrat" wrote:
I want to replace zeros with blanks. In the Find tab of the Find/Replace
dialog box I can choose to find the zeros in values as opposed to formulas.
However, when I go to the Replace tab, the only option it gives me is to
replace zeros found in formulas. How can I replace only zeros that show up
as values RESULTING from formulas?
|