Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Find and Replace function in Excel is not working? | Excel Worksheet Functions | |||
How do I find and replace null values in Excel 2002 worksheets? | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
Excel 2002 transpose not working | Excel Discussion (Misc queries) | |||
Excel 2002 not working | Setting up and Configuration of Excel |