Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 09, 01:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 505
Default Excel 2002: Why Find and Replace not working?

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




--
A36B58K641

  #2   Report Post  
Old January 6th 09, 01:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Excel 2002: Why Find and Replace not working?

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:

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




--
A36B58K641

  #3   Report Post  
Old January 6th 09, 01:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,646
Default Excel 2002: Why Find and Replace not working?

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

Regards,
Stefi

„Mr. Low” ezt *rta:

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




--
A36B58K641

  #4   Report Post  
Old January 6th 09, 02:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 505
Default Excel 2002: Why Find and Replace not working?

Hi Marcelo,

Thanks for your reply.

Best Regards

Low


--
A36B58K641


"Marcelo" wrote:

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:

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




--
A36B58K641

  #5   Report Post  
Old January 6th 09, 02:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 505
Default Excel 2002: Why Find and Replace not working?

Hi Stefi,

Thanks for your explanation.

Now I understand better.

Best Regards

Low

--

A36B58K641


"Stefi" wrote:

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

Regards,
Stefi

„Mr. Low” ezt *rta:

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




--
A36B58K641



  #6   Report Post  
Old January 6th 09, 02:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,646
Default Excel 2002: Why Find and Replace not working?

You are welcome! Thanks for the feedback!
Stefi

„Mr. Low” ezt *rta:

Hi Stefi,

Thanks for your explanation.

Now I understand better.

Best Regards

Low

--

A36B58K641


"Stefi" wrote:

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

Regards,
Stefi

„Mr. Low” ezt *rta:

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




--
A36B58K641

  #7   Report Post  
Old January 6th 09, 03:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Excel 2002: Why Find and Replace not working?

You are very welcome, thanks for the feedback.

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



"Mr. Low" escreveu:

Hi Marcelo,

Thanks for your reply.

Best Regards

Low


--
A36B58K641


"Marcelo" wrote:

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:

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




--
A36B58K641



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Find and Replace function in Excel is not working? BPeach Excel Worksheet Functions 2 December 20th 06 11:27 PM
How do I find and replace null values in Excel 2002 worksheets? Peter Excel Worksheet Functions 5 October 27th 06 04:53 AM
Despite data existing in Excel 2002 spreadsheet Find doesn't find AnnieB Excel Discussion (Misc queries) 1 June 16th 06 02:15 AM
Excel 2002 transpose not working joeeng Excel Discussion (Misc queries) 2 July 8th 05 11:13 PM
Excel 2002 not working Help IN Nebraska. Setting up and Configuration of Excel 2 December 22nd 04 10:29 AM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017