Re: Finding 0s in Excel 97 and Excel 2002

Giganews Newsgroups
Subject: Re: Finding 0s in Excel 97 and Excel 2002
Posted by:  Evi (evwoolTakeThisO…
Date: Tue, 14 Oct 2003

Sorry, in the bit about 97 I accidentally used the Find Replace box to do my
Find.  I could find the 0 with the Find box if I chose Find Values and Whole
Cell. But I still want to know how to find 0s in order to replace them.
"Evi" <evwoolTakeThisO…> wrote in message
> In Excel 97, if I try to use the Find box to find a 0 that is the result
> a formula (=8-8), it doesn't find it (though it will find 0 that is typed
> into a cell or other numbers that are the result of a formula).
> In Excel 2002, I can find the 0 by choosing the Value option in the Find
> but if I try to find the same cell using the Find And Replace box (so that
> can replace all those 0s with another number rather than with a formula
> results in 0), the Value option is no longer there and suddenly Excel can
> longer find the 0.
> Any ideas what is going on and is there a way I can find my 0s in Excel 97
> and replace them in Excel 2002.
> Evi


In response to

Finding 0s in Excel 97 and Excel 2002 posted by Evi on Tue, 14 Oct 2003