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…@ntlworld.com)
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
"Evi" <evwoolTakeThisO…@ntlworld.com> wrote in message
news:bmhr33$mvbev$…@ID-165649.news.uni-berlin.de...
> In Excel 97, if I try to use the Find box to find a 0 that is the result
of
> 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
box
> but if I try to find the same cell using the Find And Replace box (so that
I
> can replace all those 0s with another number rather than with a formula
that
> results in 0), the Value option is no longer there and suddenly Excel can
no
> 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

Replies

In response to

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