View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Riverrat
 
Posts: n/a
Default How do I replace numbers in a value NOT a formula?

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?