- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Re: Finding 0s in Excel 97 and Excel 2002

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

- Re: Finding 0s in Excel 97 and Excel 2002 posted by GB on Tue, 14 Oct 2003

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