Excel 2002: Why Find and Replace not working?

M

Mr. Low

Hi,

I do not have any problem using Find and Replace to locate zeroes (0) in a
column most of the time.

I noticed that this is only working for cell that has the cell content 0.00
displayed at the formula bar.

For certain 0.00 cells the has the cell content displayed as
6.3664629124105E-12 or something similar at the formula bar, this function is
not working.

May I know why and how to overcome it?


Thanks

Low
 
M

Marcelo

Find and replace are working,

6.3664629124105E-12 is not zero

one way to solve it, use round funcion

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mr. Low" escreveu:
 
S

Stefi

Because 6.3664629124105E-12 is a very small number (in scientific format)
but not 0!

Regards,
Stefi

„Mr. Low†ezt írta:
 
M

Mr. Low

Hi Stefi,

Thanks for your explanation.

Now I understand better.

Best Regards

Low
 
M

Marcelo

You are very welcome, thanks for the feedback.

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mr. Low" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to find 0.00 in a column of number? 4
Use Find and Replace in Excel 2
Find and replace a value within a formula 2
Excel 2002 : How to eliminate _ before a cell address in a formula 1
Find / Replace 3
Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? 6
how to find and replace content of a specific cell based on its ad 4
Format Cells - Accounting - Discrepancy? 3

Top