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

Optionbutton Not working 3
Word macro that can call cells out of Excel for a find and replace 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Menu Macro Not Executing - Need Help 1
find and replace formula text? 0
Excel 2002: How to find 0.00 in a column of number? 4
Excel 2002 : How to eliminate _ before a cell address in a formula 1
Find and Replace variable string 15

Top